Skip to content

Instantly share code, notes, and snippets.

@joemontibello

joemontibello/smallsample.csv Secret

Created February 2, 2021 15:07
Show Gist options
  • Save joemontibello/0b4f5f456da7cdc56651acf03af11fc5 to your computer and use it in GitHub Desktop.
Save joemontibello/0b4f5f456da7cdc56651acf03af11fc5 to your computer and use it in GitHub Desktop.
Download ZIP
Openrefine performance question
Raw
smallsample.csv
ID ORIGINAL_ID TRANSACTION_GMT 1 TRANSACTION_GMT 2 FY APPLICATION_NAME SOURCE_CODE OP_CODE ITEM_RECORD_ID VOLUME_RECORD_ID BIB_RECORD_ID STAT_GROUP_CODE_NUM DUE_DATE_GMT COUNT_TYPE_CODE_NUM ITYPE_CODE_NUM ICODE1-codes for projects, not circulation ICODE2-Suppression code ITEM_LOCATION_CODE ITEM_AGENCY_CODE_NUM PTYPE_CODE Description III Stat Cat Department/affiliation PCODE4 LOANRULE_CODE_NUM
1 435834 2015 11 2016 sierra local Checkout 450975682100 420911505696 Baker-Berry 2015-11-15 14:49:46.000000 0 monograph 0 k BAKER CIRC DESK 0 Undergrad DART COLL STU UNDERGRAD EDUCATION -1
2 435839 2015 11 2016 sierra local Checkout 450976313472 420913010399 Kresge 2015-11-15 16:11:25.000000 0 4-hour Reserve 0 - KRESGE COURSERSRV 0 Undergrad DART COLL STU UNDERGRAD None -1
3 435859 2015 11 2016 sierra local Checkin 450976260551 420912771880 Baker-Berry 2016-03-14 04:00:00.000000 0 monograph 0 - BAKER STACKS 0 Staff Blank Value STAFF LINGUISTICS -1
4 435860 2015 11 2016 sierra local Renewal 450976253324 420912748683 Baker-Berry 2016-03-14 04:00:00.000000 0 monograph 0 - BAKER STACKS 0 Student Plus DART COLL STU UNDERGRAD HIGH SCHOOL -1
5 435861 2015 11 2016 sierra local Renewal 450976271347 420912834616 Baker-Berry 2016-03-14 04:00:00.000000 0 monograph 0 - BAKER STACKS 0 Student Plus DART COLL STU UNDERGRAD HIGH SCHOOL -1
6 435811 2015 11 2016 sierra local Checkout 450975659526 420911505696 Baker-Berry 2015-11-15 14:21:57.000000 0 monograph 0 k BAKER CIRC DESK 0 Undergrad DART COLL STU UNDERGRAD RADIOLOGY -1
7 435825 2015 11 2016 sierra local Checkout 450975652585 420911497057 Baker Reserves 2015-11-16 11:00:00.000000 0 24-hour Reserve 0 - BAKER ONRESPRM 0 Undergrad DART COLL STU UNDERGRAD None -1
8 435827 2015 11 2016 sierra local Checkout 450975748209 420911715117 Baker-Berry 2015-12-13 04:00:00.000000 0 monograph 0 - BAKER STACKS 0 Undergrad DART COLL STU UNDERGRAD None -1
9 435828 2015 11 2016 sierra local Checkout 450973640722 420908960944 Baker-Berry 2015-12-13 04:00:00.000000 0 monograph 0 - BAKER STACKS 0 Undergrad DART COLL STU UNDERGRAD None -1
10 435833 2015 11 2016 sierra local Checkout 450975659528 420911505696 Baker-Berry 2015-11-15 14:45:44.000000 0 monograph 0 k BAKER CIRC DESK 0 Undergrad DART COLL STU UNDERGRAD RADIOLOGY -1
11 435842 2015 11 2016 sierra local Checkin 450976281168 420912879901 Baker-Berry 2015-11-15 13:11:04.000000 0 monograph 0 k BAKER CIRC DESK 0 Undergrad DART COLL STU UNDERGRAD None -1
12 435845 2015 11 2016 sierra local Checkout 450976300759 420912879902 Baker-Berry 2015-11-15 15:25:34.000000 0 monograph 0 k BAKER CIRC DESK 0 Undergrad DART COLL STU UNDERGRAD None -1
13 435826 2015 11 2016 sierra local Checkin 450974464988 420909451294 Kresge 2015-12-11 04:00:00.000000 0 monograph 0 - KRESGE STACKS 0 Undergrad DART COLL STU UNDERGRAD PHYSIOLOGY (DMS) -1
14 435836 2015 11 2016 sierra local Checkin 450975820896 420912057266 Baker-Berry 2015-11-15 13:35:55.000000 0 monograph 0 5 BAKER CIRC DESK 0 Undergrad DART COLL STU UNDERGRAD None -1
Raw
transforms.json
[
{
"op": "core/text-transform",
"description": "Text transform on cells in column TRANSACTION_GMT using expression grel:substring(cells['TRANSACTION_GMT'].value, 0, 10)",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"columnName": "TRANSACTION_GMT",
"expression": "grel:substring(cells['TRANSACTION_GMT'].value, 0, 10)",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/column-split",
"description": "Split column TRANSACTION_GMT by separator",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"columnName": "TRANSACTION_GMT",
"guessCellType": true,
"removeOriginalColumn": true,
"mode": "separator",
"separator": "-",
"regex": false,
"maxColumns": 0
},
{
"op": "core/column-removal",
"description": "Remove column TRANSACTION_GMT 3",
"columnName": "TRANSACTION_GMT 3"
},
{
"op": "core/column-addition",
"description": "Create column FY at index 4 based on column TRANSACTION_GMT 2 using expression grel:if(cells[\"TRANSACTION_GMT 2\"].value > 6, cells[\"TRANSACTION_GMT 1\"].value + 1, cells[\"TRANSACTION_GMT 1\"].value)",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"newColumnName": "FY",
"columnInsertIndex": 4,
"baseColumnName": "TRANSACTION_GMT 2",
"expression": "grel:if(cells[\"TRANSACTION_GMT 2\"].value > 6, cells[\"TRANSACTION_GMT 1\"].value + 1, cells[\"TRANSACTION_GMT 1\"].value)",
"onError": "set-to-blank"
},
{
"op": "core/column-removal",
"description": "Remove column PATRON_HOME_LIBRARY_CODE",
"columnName": "PATRON_HOME_LIBRARY_CODE"
},
{
"op": "core/column-removal",
"description": "Remove column PATRON_AGENCY_CODE_NUM",
"columnName": "PATRON_AGENCY_CODE_NUM"
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column OP_CODE using expression grel:if(value == 'o', 'Checkout',\nif(value == 'i', 'Checkin',\nif(value == 'r', 'Renewal',\nif(value == 'h', 'Hold recall',\nif(value == 'hi', 'Hold recall item',\nif(value == 'hb', 'Hold recall bib',\nif(value == 'hv', 'Hold recall volume',\nif(value == 'f', 'Hold fulfilled',\nif(value == 'n', 'Hold',\nif(value == 'nb', 'Bib hold',\nif(value == 'ni', 'Item hold',\nif(value == 'u', 'Use count',\nif(value == 'b', 'Booking', value)))))))))))))",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"columnName": "OP_CODE",
"expression": "grel:if(value == 'o', 'Checkout',\nif(value == 'i', 'Checkin',\nif(value == 'r', 'Renewal',\nif(value == 'h', 'Hold recall',\nif(value == 'hi', 'Hold recall item',\nif(value == 'hb', 'Hold recall bib',\nif(value == 'hv', 'Hold recall volume',\nif(value == 'f', 'Hold fulfilled',\nif(value == 'n', 'Hold',\nif(value == 'nb', 'Bib hold',\nif(value == 'ni', 'Item hold',\nif(value == 'u', 'Use count',\nif(value == 'b', 'Booking', value)))))))))))))",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column STAT_GROUP_CODE_NUM using expression grel:if(value == '0', 'Baker-Berry',\nif(value == '101', 'Baker-Berry',\nif(value == '103', 'Rauner',\nif(value == '104', 'Baker-Berry',\nif(value == '106', 'Baker-Berry',\nif(value == '110', 'Baker-Berry',\nif(value == '115', 'Baker Resource Sharing',\nif(value == '120', 'Baker Reserves',\nif(value == '140', 'Jones Media Center',\nif(value == '150', 'Baker-Berry',\nif(value == '190', 'Evans Map Room',\nif(value == '210', 'Sherman',\nif(value == '330', 'Dana',\nif(value == '410', 'MFHSL',\nif(value == '510', 'Paddock',\nif(value == '610', 'Feldberg',\nif(value == '710', 'Kresge',\nif(value == '800', 'Webpac',\nif(value == '802', 'Webpac',\nif(value == '804', 'Webpac',\nif(value == '820', 'DLD', value)))))))))))))))))))))",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"columnName": "STAT_GROUP_CODE_NUM",
"expression": "grel:if(value == '0', 'Baker-Berry',\nif(value == '101', 'Baker-Berry',\nif(value == '103', 'Rauner',\nif(value == '104', 'Baker-Berry',\nif(value == '106', 'Baker-Berry',\nif(value == '110', 'Baker-Berry',\nif(value == '115', 'Baker Resource Sharing',\nif(value == '120', 'Baker Reserves',\nif(value == '140', 'Jones Media Center',\nif(value == '150', 'Baker-Berry',\nif(value == '190', 'Evans Map Room',\nif(value == '210', 'Sherman',\nif(value == '330', 'Dana',\nif(value == '410', 'MFHSL',\nif(value == '510', 'Paddock',\nif(value == '610', 'Feldberg',\nif(value == '710', 'Kresge',\nif(value == '800', 'Webpac',\nif(value == '802', 'Webpac',\nif(value == '804', 'Webpac',\nif(value == '820', 'DLD', value)))))))))))))))))))))",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column ITYPE_CODE_NUM using expression grel:if(value == '0', 'monograph',\nif(value == '1', 'gov docs',\nif(value == '2', 'catalog',\nif(value == '3', 'compact disc',\nif(value == '4', 'cd-rom',\nif(value == '5', 'diskette',\nif(value == '6', 'equipment',\nif(value == '7', 'film',\nif(value == '8', 'iconograph',\nif(value == '9', 'journal',\nif(value == '10', 'journal non-circ',\nif(value == '11', 'magnetic tape',\nif(value == '12', 'manuscript',\nif(value == '13', 'map',\nif(value == '14', 'microform',\nif(value == '15', 'monograph non-circ',\nif(value == '16', 'newspaper',\nif(value == '17', 'pamphlet',\nif(value == '18', 'personal copy',\nif(value == '19', 'phonodisc',\nif(value == '20', 'phonotape',\nif(value == '21', 'photocopy',\nif(value == '22', 'realia',\nif(value == '23', 'score',\nif(value == '24', 'serial',\nif(value == '25', 'slide',\nif(value == '26', 'thesis',\nif(value == '27', 'DVDvideodisc',\nif(value == '28', 'VHS videotape',\nif(value == '29', 'serial non-circ',\nif(value == '30', '2-hour Reserve',\nif(value == '31', '24-hour Reserve',\nif(value == '32', 'Summary item circ',\nif(value == '33', 'map non-circ',\nif(value == '34', '4-hour Reserve',\nif(value == '35', 'Summary item non-circ',\nif(value == '36', '7-day Reserve',\nif(value == '37', 'Manual circulation',\nif(value == '38', 'Copy card',\nif(value == '39', 'Marcive',\nif(value == '40', 'E-resource (dcres)',\nif(value == '41', '3-day Reserve',\nif(value == '42', 'Matthews Fuller 7 day',\nif(value == '43', '2-week Reserve',\nif(value == '44', 'Internal Library Publication',\nif(value == '45', 'Key',\nif(value == '46', 'Baker Reserves In House Use Only',\nif(value == '47', 'DVCAM videotape',\nif(value == '48', 'Jones Media In House Use Only',\nif(value == '49', 'cd-rom non-circulate',\nif(value == '50', 'Scholar Studies 1 yr',\nif(value == '51', 'Scholar Studies 1 term',\nif(value == '52', 'Scholar Studies 1 month',\nif(value == '53', 'Scholar Studies 1 week',\nif(value == '54', 'Scholar Studies 1 day',\nif(value == '55', 'Pro Equipment',\nif(value == '56', 'Basic Equipment',\nif(value == '57', 'E-Reserve (rserv)',\nif(value == '58', 'Attched Media',\nif(value == '59', 'Kaplan Materials',\nif(value == '60', 'Restricted Use',\nif(value == '61', 'JMC remotes and drives',\nif(value == '62', 'Jones Reserves',\nif(value == '63', 'BorrowDirect',\nif(value == '64', 'DartDoc',\nif(value == '65', 'XDCam',\nif(value == '66', 'Depository View at Rauner Only',\nif(value == '67', 'View in Project Rm Only',\nif(value == '68', 'Student Life Support Manuals',\nif(value == '69', 'Display Material',\nif(value == '70', 'Hard drive',\nif(value == '71', 'Instructor Life Supprt Manuals',\nif(value == '72', '2-day Reserve',\nif(value == '73', 'BorrowDirect Recall',\nif(value == '74', 'DartDoc 2 Week',\nif(value == '75', 'DartDoc 4 Week',\nif(value == '76', 'DartDoc 8 Week',\nif(value == '77', 'DartDoc 6 Month',\nif(value == '78', 'DartDoc 16 Week',\nif(value == '80', 'Boardgame',\nif(value == '81', 'Videogame',\nif(value == '82', '7 Day Equipment',\nif(value == '100', 'mat booking', value)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"columnName": "ITYPE_CODE_NUM",
"expression": "grel:if(value == '0', 'monograph',\nif(value == '1', 'gov docs',\nif(value == '2', 'catalog',\nif(value == '3', 'compact disc',\nif(value == '4', 'cd-rom',\nif(value == '5', 'diskette',\nif(value == '6', 'equipment',\nif(value == '7', 'film',\nif(value == '8', 'iconograph',\nif(value == '9', 'journal',\nif(value == '10', 'journal non-circ',\nif(value == '11', 'magnetic tape',\nif(value == '12', 'manuscript',\nif(value == '13', 'map',\nif(value == '14', 'microform',\nif(value == '15', 'monograph non-circ',\nif(value == '16', 'newspaper',\nif(value == '17', 'pamphlet',\nif(value == '18', 'personal copy',\nif(value == '19', 'phonodisc',\nif(value == '20', 'phonotape',\nif(value == '21', 'photocopy',\nif(value == '22', 'realia',\nif(value == '23', 'score',\nif(value == '24', 'serial',\nif(value == '25', 'slide',\nif(value == '26', 'thesis',\nif(value == '27', 'DVDvideodisc',\nif(value == '28', 'VHS videotape',\nif(value == '29', 'serial non-circ',\nif(value == '30', '2-hour Reserve',\nif(value == '31', '24-hour Reserve',\nif(value == '32', 'Summary item circ',\nif(value == '33', 'map non-circ',\nif(value == '34', '4-hour Reserve',\nif(value == '35', 'Summary item non-circ',\nif(value == '36', '7-day Reserve',\nif(value == '37', 'Manual circulation',\nif(value == '38', 'Copy card',\nif(value == '39', 'Marcive',\nif(value == '40', 'E-resource (dcres)',\nif(value == '41', '3-day Reserve',\nif(value == '42', 'Matthews Fuller 7 day',\nif(value == '43', '2-week Reserve',\nif(value == '44', 'Internal Library Publication',\nif(value == '45', 'Key',\nif(value == '46', 'Baker Reserves In House Use Only',\nif(value == '47', 'DVCAM videotape',\nif(value == '48', 'Jones Media In House Use Only',\nif(value == '49', 'cd-rom non-circulate',\nif(value == '50', 'Scholar Studies 1 yr',\nif(value == '51', 'Scholar Studies 1 term',\nif(value == '52', 'Scholar Studies 1 month',\nif(value == '53', 'Scholar Studies 1 week',\nif(value == '54', 'Scholar Studies 1 day',\nif(value == '55', 'Pro Equipment',\nif(value == '56', 'Basic Equipment',\nif(value == '57', 'E-Reserve (rserv)',\nif(value == '58', 'Attched Media',\nif(value == '59', 'Kaplan Materials',\nif(value == '60', 'Restricted Use',\nif(value == '61', 'JMC remotes and drives',\nif(value == '62', 'Jones Reserves',\nif(value == '63', 'BorrowDirect',\nif(value == '64', 'DartDoc',\nif(value == '65', 'XDCam',\nif(value == '66', 'Depository View at Rauner Only',\nif(value == '67', 'View in Project Rm Only',\nif(value == '68', 'Student Life Support Manuals',\nif(value == '69', 'Display Material',\nif(value == '70', 'Hard drive',\nif(value == '71', 'Instructor Life Supprt Manuals',\nif(value == '72', '2-day Reserve',\nif(value == '73', 'BorrowDirect Recall',\nif(value == '74', 'DartDoc 2 Week',\nif(value == '75', 'DartDoc 4 Week',\nif(value == '76', 'DartDoc 8 Week',\nif(value == '77', 'DartDoc 6 Month',\nif(value == '78', 'DartDoc 16 Week',\nif(value == '80', 'Boardgame',\nif(value == '81', 'Videogame',\nif(value == '82', '7 Day Equipment',\nif(value == '100', 'mat booking', value)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/column-rename",
"description": "Rename column ICODE1 to ICODE1-codes for projects, not circulation",
"oldColumnName": "ICODE1",
"newColumnName": "ICODE1-codes for projects, not circulation"
},
{
"op": "core/column-rename",
"description": "Rename column ICODE2 to ICODE2-Suppression code",
"oldColumnName": "ICODE2",
"newColumnName": "ICODE2-Suppression code"
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column ITEM_LOCATION_CODE using expression grel:if(value == 'aaaa ', 'BAKER ON ORDER',if(value == 'arfo ', 'SHERMAN FOLIO',if(value == 'arof ', 'SHERMAN OFFICE',if(value == 'arov ', 'SHERMAN OVERSIZE',if(value == 'arrf ', 'SHERMAN REFERENCE',if(value == 'arrs ', 'SHERMAN NOTCATRSRV',if(value == 'arsp ', 'SHERMAN SPECIAL',if(value == 'arspr', 'EMPTY UNASSIGNED',if(value == 'artl ', 'SHERMAN STACKS',if(value == 'axsp ', 'DEPOSITORY DEPOSITORY',if(value == 'axtl ', 'DEPOSITORY DEPOSITORY',if(value == 'baaj ', 'BAKER JAPAN',if(value == 'baao ', 'BAKER JPNOVRSIZE',if(value == 'baaq ', 'BAKER ACQOFFICE',if(value == 'baar ', 'BAKER JPNREF',if(value == 'babc ', 'BAKER CATOFFICE',if(value == 'babr ', 'BAKER BKARTSREF',if(value == 'bacd ', 'BAKER CIRC DESK',if(value == 'bacf ', 'BAKER EAFOLIO',if(value == 'bach ', 'BAKER EASTASIAN',if(value == 'baci ', 'BAKER CIRCOFFICE',if(value == 'baco ', 'BAKER EAOVRSIZE',if(value == 'bacr ', 'BAKER EA REF',if(value == 'baec ', 'BAKER EVANSCLER',if(value == 'baed ', 'BAKER EDOFFICE',if(value == 'bafe ', 'BAKER RESLOCKFER',if(value == 'baff ', 'BAKER REF FOLIO',if(value == 'bafo ', 'BAKER FOLIO',if(value == 'bagd ', 'BAKER GOVDOCS',if(value == 'bagdr', 'JONES CDROM',if(value == 'baha ', 'BAKER HARVARDCOL',if(value == 'bail ', 'BAKER ILLOFFICE',if(value == 'bailm', 'BAKER ILLOFFICEM',if(value == 'bais ', 'BAKER DLTGOFFICE',if(value == 'bajm ', 'JONES JMC',if(value == 'bajma', 'JONES PHONOTAPE',if(value == 'bajmc', 'JONES COMPACTDSC',if(value == 'bajmd', 'JONES JONESMSTR',if(value == 'bajmj', 'EMPTY UNASSIGNED',if(value == 'bajmo', 'JONES BOARDGAME',if(value == 'bajmq', 'JONES DISKETTE',if(value == 'bajmr', 'JONES CDROM',if(value == 'bajms', 'EMPTY UNASSIGNED',if(value == 'bajmv', 'JONES VIDEOTAPE',if(value == 'bajmw', 'JONES VIDEOGAME',if(value == 'bajmx', 'JONES VCD',if(value == 'bajmy', 'JONES DVDROM',if(value == 'bajmz', 'JONES DVD',if(value == 'bajo ', 'JONES OFFICE',if(value == 'bajr ', 'JONES REFERENCE',if(value == 'bake ', 'BAKER TOWERROOMK',if(value == 'bakr ', 'BAKER STACKS',if(value == 'bali ', 'BAKER OFFICE',if(value == 'bamc ', 'BAKER EVANSCIA',if(value == 'bamp ', 'BAKER EVANS',if(value == 'bampk', 'BAKER EVANSVDDSC',if(value == 'bampq', 'BAKER EVANSDSKET',if(value == 'bampr', 'BAKER EVANSCDROM',if(value == 'bampy', 'BAKER EVANSDVDRM',if(value == 'bamr ', 'BAKER EVANSREF',if(value == 'bamrr', 'BAKER EVANSRFCDR',if(value == 'bams ', 'BAKER EVANSSPEC',if(value == 'bana ', 'BAKER NASH',if(value == 'banf ', 'BAKER NASH FOLIO',if(value == 'bano ', 'BAKER NASHOVRSIZ',if(value == 'banp ', 'EMPTY UNASSIGNED',if(value == 'baod ', 'BAKER OLD DART',if(value == 'baov ', 'BAKER OVERSIZE',if(value == 'bapr ', 'BAKER PRESOFFICE',if(value == 'bard ', 'BAKER REF DESK',if(value == 'bare ', 'BAKER REF OFFICE',if(value == 'barf ', 'BAKER REFERENCE',if(value == 'barfm', 'EMPTY UNASSIGNED',if(value == 'barfq', 'EMPTY UNASSIGNED',if(value == 'barfr', 'BAKER CDROM',if(value == 'baro ', 'BAKER REFOVRSIZE',if(value == 'barp ', 'BAKER RESERVE',if(value == 'barph', 'BAKER RESERVEFLM',if(value == 'barpm', 'BAKER RESERVEFCH',if(value == 'barrh', 'BAKER RESPRMFILM',if(value == 'bars ', 'BAKER NOTCATRSRV',if(value == 'bash ', 'BAKER TOWERROOMS',if(value == 'basr ', 'BAKER EASTREADRM',if(value == 'bast ', 'BAKER TOWERROOMT',if(value == 'batc ', 'BAKER CPRBALCONY',if(value == 'batr ', 'BAKER TOWERROOM',if(value == 'bawe ', 'BAKER DEWEY',if(value == 'baxk ', 'BAKER KOREA',if(value == 'baxo ', 'BAKER KOROVERSIZ',if(value == 'baxr ', 'BAKER KORREF',if(value == 'bfjmu', 'JONES FILMSTRG',if(value == 'bxaj ', 'DEPOSITORY DEPOSITORY',if(value == 'bxch ', 'DEPOSITORY DEPOSITORY',if(value == 'bxjm ', 'DEPOSITORY DEPOSITORY',if(value == 'bxjmg', 'DEPOSITORY DEPOSITORY',if(value == 'bxjmh', 'DEPOSITORY DEPOSITORY',if(value == 'bxjmk', 'DEPOSITORY DEPOSITORY',if(value == 'bxjmm', 'DEPOSITORY DEPOSITORY',if(value == 'bxkr ', 'DEPOSITORY DEPOSITORY',if(value == 'bxkrg', 'DEPOSITORY DEPOSITORY',if(value == 'bxkrh', 'DEPOSITORY DEPOSITORY',if(value == 'bxkrj', 'DEPOSITORY DEPOSITORY',if(value == 'bxkrm', 'DEPOSITORY DEPOSITORY',if(value == 'bxmp ', 'DEPOSITORY DEPOSITORY',if(value == 'bxos ', 'DEPOSITORY DEPOSITORY',if(value == 'bxre ', 'DEPOSITORY DEPOSITORY',if(value == 'bxsp ', 'DEPOSITORY DEPOSITORY',if(value == 'bzjmh', 'DEPOSITORY DEPOSITORY',if(value == 'bzkr ', 'DEPOSITORY DEPOSITORY',if(value == 'bzkrg', 'DEPOSITORY DEPOSITORY',if(value == 'coez ', 'BAKER COOK EASY',if(value == 'cook ', 'BAKER COOK',if(value == 'cookt', 'BAKER COOKTHESIS',if(value == 'coov ', 'BAKER COOKOVRSIZ',if(value == 'cxok ', 'DEPOSITORY DEPOSITORY',if(value == 'dana ', 'DANA STACKS',if(value == 'danam', 'EMPTY UNASSIGNED',if(value == 'danas', 'EMPTY UNASSIGNED',if(value == 'danat', 'DANA THESIS',if(value == 'danav', 'EMPTY UNASSIGNED',if(value == 'danaz', 'DANA DVD',if(value == 'daof ', 'EMPTY UNASSIGNED',if(value == 'daos ', 'EMPTY UNASSIGNED',if(value == 'darf ', 'EMPTY UNASSIGNED',if(value == 'dars ', 'DANA NOTCATRSRV',if(value == 'dasp ', 'EMPTY UNASSIGNED',if(value == 'dcres', 'BAKER ONLINE',if(value == 'dxna ', 'DEPOSITORY DEPOSITORY',if(value == 'dzna ', 'DEPOSITORY DEPOSITORY',if(value == 'feld ', 'FELDBERG STACKS',if(value == 'feldc', 'EMPTY UNASSIGNED',if(value == 'feldh', 'EMPTY UNASSIGNED',if(value == 'feldm', 'EMPTY UNASSIGNED',if(value == 'feldt', 'FELDBERG THESIS',if(value == 'feme ', 'FELDBERG MEM',if(value == 'feof ', 'EMPTY UNASSIGNED',if(value == 'fepr ', 'FELDBERG PERMRSRV',if(value == 'ferf ', 'FELDBERG REFERENCE',if(value == 'ferfr', 'FELDBERG REFCDROM',if(value == 'ferfv', 'EMPTY UNASSIGNED',if(value == 'fers ', 'FELDBERG NOTCATRSRV',if(value == 'fesp ', 'EMPTY UNASSIGNED',if(value == 'fxld ', 'DEPOSITORY DEPOSITORY',if(value == 'fxldh', 'DEPOSITORY DEPOSITORY',if(value == 'fxldm', 'DEPOSITORY DEPOSITORY',if(value == 'fxsp ', 'DEPOSITORY DEPOSITORY',if(value == 'krcd ', 'KRESGE DESK',if(value == 'kres ', 'KRESGE STACKS',if(value == 'kresh', 'EMPTY UNASSIGNED',if(value == 'kresi', 'KRESGE ICNGRAPHY',if(value == 'kresr', 'KRESGE CDROM',if(value == 'krest', 'KRESGE THESIS',if(value == 'kresy', 'KRESGE DVDROM',if(value == 'krfo ', 'KRESGE REFOVRSIZE',if(value == 'krmp ', 'KRESGE MAP',if(value == 'krof ', 'EMPTY UNASSIGNED',if(value == 'krov ', 'KRESGE OVERSIZE',if(value == 'krps ', 'KRESGE POPSCI',if(value == 'krrf ', 'KRESGE REFERENCE',if(value == 'krrfr', 'KRESGE REFCDROM',if(value == 'krrs ', 'KRESGE NOTCATRSRV',if(value == 'kxes ', 'DEPOSITORY DEPOSITORY',if(value == 'kxesh', 'DEPOSITORY DEPOSITORY',if(value == 'kxesm', 'DEPOSITORY DEPOSITORY',if(value == 'kzes ', 'DEPOSITORY DEPOSITORY',if(value == 'mfch ', 'MFHSL CONSHEALTH',if(value == 'mfchc', 'MFHSL CHCD',if(value == 'mfchv', 'MFHSL CHVIDTAPE',if(value == 'mfchz', 'MFHSL CHDVD',if(value == 'mflb ', 'MFHSL STACKS',if(value == 'mflbe', 'MFHSL REALIA',if(value == 'mflbr', 'MFHSL CDROM',if(value == 'mflbs', 'MFHSL SLIDE',if(value == 'mflbv', 'MFHSL VIDEOTAPE',if(value == 'mflby', 'MFHSL DVDROM',if(value == 'mflbz', 'MFHSL DVD',if(value == 'mfrf ', 'MFHSL REFERENCE',if(value == 'mxlb ', 'DEPOSITORY DEPOSITORY',if(value == 'none ', 'BAKER ON ORDER',if(value == 'padd ', 'PADDOCK STACKS',if(value == 'padda', 'PADDOCK PHONOTAPE',if(value == 'paddc', 'PADDOCK COMPACTDSC',if(value == 'paddh', 'PADDOCK MICROFILM',if(value == 'paddk', 'PADDOCK VIDEODISC',if(value == 'paddp', 'PADDOCK PHONODISC',if(value == 'paddr', 'PADDOCK CDROM',if(value == 'paddt', 'PADDOCK THESIS',if(value == 'paddv', 'PADDOCK VIDEOTAPE',if(value == 'paddx', 'PADDOCK VCD',if(value == 'paddy', 'PADDOCK DVDROM',if(value == 'paddz', 'PADDOCK DVD',if(value == 'paof ', 'PADDOCK OFFICE',if(value == 'parf ', 'PADDOCK REFERENCE',if(value == 'parfc', 'PADDOCK REFCD',if(value == 'parfr', 'PADDOCK REFCDROM',if(value == 'pars ', 'PADDOCK NOTCATRSRV',if(value == 'pasp ', 'PADDOCK SPECIAL',if(value == 'pxbra', 'DEPOSITORY DEPOSITORY',if(value == 'pxdd ', 'DEPOSITORY DEPOSITORY',if(value == 'pxddp', 'DEPOSITORY DEPOSITORY',if(value == 'rsart', 'SHERMAN COURSERSRV',if(value == 'rsbak', 'BAKER COURSERSRV',if(value == 'rsbue', 'FELDBERG COURSERSRV',if(value == 'rsdan', 'DANA COURSERSRV',if(value == 'rserv', 'BAKER ONLINE',if(value == 'rshsl', 'MFHSL COURSERSRV',if(value == 'rsjmc', 'JONES COURSERSRV',if(value == 'rsmus', 'PADDOCK COURSERSRV',if(value == 'rsphs', 'KRESGE COURSERSRV',if(value == 'rspro', 'BAKER ONRESPRM',if(value == 'rsstf', 'BAKER RESPRM',if(value == 'uncat', 'EMPTY UNASSIGNED',if(value == 'w1926', 'RAUNER W1926',if(value == 'walu ', 'RAUNER WALU',if(value == 'wbal ', 'RAUNER WBAL',if(value == 'wbib ', 'RAUNER WBIB',if(value == 'wbie ', 'RAUNER WBIE',if(value == 'wbin ', 'RAUNER WBIN',if(value == 'wblu ', 'RAUNER WBLU',if(value == 'wbrl ', 'RAUNER WBRL',if(value == 'wbro ', 'RAUNER WBRO',if(value == 'wbry ', 'RAUNER WBRY',if(value == 'wbur ', 'RAUNER WBUR',if(value == 'wcad ', 'RAUNER WCAD',if(value == 'wcadb', 'RAUNER WCADB',if(value == 'wcal ', 'RAUNER WCAL',if(value == 'wcan ', 'RAUNER WCAN',if(value == 'wchg ', 'RAUNER WCHG',if(value == 'wchn ', 'RAUNER WCHN',if(value == 'wchs ', 'RAUNER WCHS',if(value == 'wchsb', 'RAUNER WCHSB',if(value == 'wcng ', 'RAUNER WCNG',if(value == 'wcon ', 'RAUNER WCON',if(value == 'wcra ', 'RAUNER WCRA',if(value == 'wcug ', 'RAUNER WCUG',if(value == 'wcus ', 'RAUNER WCUS',if(value == 'wdca ', 'RAUNER WDCA',if(value == 'wdch ', 'RAUNER WDCH',if(value == 'wdchb', 'RAUNER WDCHB',if(value == 'wdcl ', 'RAUNER WDCL',if(value == 'wdcm ', 'RAUNER WDCM',if(value == 'wdcn ', 'RAUNER WDCN',if(value == 'wdco ', 'RAUNER WDCO',if(value == 'wdct ', 'RAUNER WDCT',if(value == 'wdcu ', 'RAUNER WDCU',if(value == 'wdew ', 'RAUNER WDEW',if(value == 'wdim ', 'RAUNER WDIM',if(value == 'wdog ', 'RAUNER WDOG',if(value == 'wdol ', 'RAUNER WDOL',if(value == 'webe ', 'RAUNER WEBE',if(value == 'webeb', 'RAUNER WEBEB',if(value == 'wedt ', 'RAUNER WEDT',if(value == 'wfie ', 'RAUNER WFIE',if(value == 'wfro ', 'RAUNER WFRO',if(value == 'wfrob', 'RAUNER WFROB',if(value == 'wgar ', 'RAUNER WGAR',if(value == 'wgil ', 'RAUNER WGIL',if(value == 'wgra ', 'RAUNER WGRA',if(value == 'whew ', 'RAUNER WHEW',if(value == 'whic ', 'RAUNER WHIC',if(value == 'whil ', 'RAUNER WHIL',if(value == 'whot ', 'RAUNER WHOT',if(value == 'whud ', 'RAUNER WHUD',if(value == 'whun ', 'RAUNER WHUN',if(value == 'whux ', 'RAUNER WHUX',if(value == 'will ', 'RAUNER WILL',if(value == 'willb', 'RAUNER WILLB',if(value == 'winc ', 'RAUNER WINC',if(value == 'withd', 'BAKER WITHDRAWN',if(value == 'wlan ', 'RAUNER WLAN',if(value == 'wlanb', 'RAUNER WLANB',if(value == 'wlaw ', 'RAUNER WLAW',if(value == 'wlin ', 'RAUNER WLIN',if(value == 'wlog ', 'RAUNER WLOG',if(value == 'wlon ', 'RAUNER WLON',if(value == 'wmac ', 'RAUNER WMAC',if(value == 'wmaf ', 'RAUNER WMAF',if(value == 'wman ', 'RAUNER WMAN',if(value == 'wmas ', 'RAUNER WMAS',if(value == 'wmcg ', 'RAUNER WMCG',if(value == 'wmeb ', 'RAUNER WMEB',if(value == 'wmebb', 'RAUNER WMEBB',if(value == 'wmel ', 'RAUNER WMEL',if(value == 'wmen ', 'RAUNER WMEN',if(value == 'wmfr ', 'RAUNER WMFR',if(value == 'wmhi ', 'RAUNER WMHI',if(value == 'wmin ', 'RAUNER WMIN',if(value == 'wmmc ', 'RAUNER WMMC',if(value == 'wmnc ', 'RAUNER WMNC',if(value == 'wmru ', 'RAUNER WMRU',if(value == 'wmst ', 'RAUNER WMST',if(value == 'wmwe ', 'RAUNER WMWE',if(value == 'wnal ', 'RAUNER WNAL',if(value == 'wnam ', 'RAUNER WNAM',if(value == 'wnan ', 'RAUNER WNAN',if(value == 'wnas ', 'RAUNER WNAS',if(value == 'wnba ', 'RAUNER WNBA',if(value == 'wnbo ', 'RAUNER WNBO',if(value == 'wnbr ', 'RAUNER WNBR',if(value == 'wnca ', 'RAUNER WNCA',if(value == 'wnch ', 'RAUNER WNCH',if(value == 'wncl ', 'RAUNER WNCL',if(value == 'wncn ', 'RAUNER WNCN',if(value == 'wnco ', 'RAUNER WNCO',if(value == 'wncr ', 'RAUNER WNCR',if(value == 'wnde ', 'RAUNER WNDE',if(value == 'wndn ', 'RAUNER WNDN',if(value == 'wndo ', 'RAUNER WNDO',if(value == 'wndu ', 'RAUNER WNDU',if(value == 'wnea ', 'RAUNER WNEA',if(value == 'wneb ', 'RAUNER WNEB',if(value == 'wnec ', 'RAUNER WNEC',if(value == 'wnen ', 'RAUNER WNEN',if(value == 'wnep ', 'RAUNER WNEP',if(value == 'wnex ', 'RAUNER WNEX',if(value == 'wnfa ', 'RAUNER WNFA',if(value == 'wnff ', 'RAUNER WNFF',if(value == 'wnfr ', 'RAUNER WNFR',if(value == 'wnfs ', 'RAUNER WNFS',if(value == 'wnfz ', 'RAUNER WNFZ',if(value == 'wngf ', 'RAUNER WNGF',if(value == 'wngl ', 'RAUNER WNGL',if(value == 'wngo ', 'RAUNER WNGO',if(value == 'wngr ', 'RAUNER WNGR',if(value == 'wngt ', 'RAUNER WNGT',if(value == 'wnha ', 'RAUNER WNHA',if(value == 'wnhf ', 'RAUNER WNHF',if(value == 'wnhi ', 'RAUNER WNHI',if(value == 'wnhn ', 'RAUNER WNHN',if(value == 'wnho ', 'RAUNER WNHO',if(value == 'wnhv ', 'RAUNER WNHV',if(value == 'wnja ', 'RAUNER WNJA',if(value == 'wnke ', 'RAUNER WNKE',if(value == 'wnlc ', 'RAUNER WNLC',if(value == 'wnle ', 'RAUNER WNLE',if(value == 'wnli ', 'RAUNER WNLI',if(value == 'wnlk ', 'RAUNER WNLK',if(value == 'wnln ', 'RAUNER WNLN',if(value == 'wnma ', 'RAUNER WNMA',if(value == 'wnmb ', 'RAUNER WNMB',if(value == 'wnmd ', 'RAUNER WNMD',if(value == 'wnmi ', 'RAUNER WNMI',if(value == 'wnml ', 'RAUNER WNML',if(value == 'wnmr ', 'RAUNER WNMR',if(value == 'wnna ', 'RAUNER WNNA',if(value == 'wnne ', 'RAUNER WNNE',if(value == 'wnnf ', 'RAUNER WNNF',if(value == 'wnnh ', 'RAUNER WNNH',if(value == 'wnni ', 'RAUNER WNNI',if(value == 'wnpl ', 'RAUNER WNPL',if(value == 'wnpm ', 'RAUNER WNPM',if(value == 'wnpn ', 'RAUNER WNPN',if(value == 'wnpo ', 'RAUNER WNPO',if(value == 'wnpt ', 'RAUNER WNPT',if(value == 'wnro ', 'RAUNER WNRO',if(value == 'wnru ', 'RAUNER WNRU',if(value == 'wnsd ', 'RAUNER WNSD',if(value == 'wnsh ', 'RAUNER WNSH',if(value == 'wnso ', 'RAUNER WNSO',if(value == 'wnsp ', 'RAUNER WNSP',if(value == 'wnsr ', 'RAUNER WNSR',if(value == 'wnst ', 'RAUNER WNST',if(value == 'wnsu ', 'RAUNER WNSU',if(value == 'wnsv ', 'RAUNER WNSV',if(value == 'wnsw ', 'RAUNER WNSW',if(value == 'wnwc ', 'RAUNER WNWC',if(value == 'wnwd ', 'RAUNER WNWD',if(value == 'wnwe ', 'RAUNER WNWE',if(value == 'wnwf ', 'RAUNER WNWF',if(value == 'wnwh ', 'RAUNER WNWH',if(value == 'wnwl ', 'RAUNER WNWL',if(value == 'wnwn ', 'RAUNER WNWN',if(value == 'wnwr ', 'RAUNER WNWR',if(value == 'wnwv ', 'RAUNER WNWV',if(value == 'wocc ', 'RAUNER WOCC',if(value == 'woli ', 'RAUNER WOLI',if(value == 'wone ', 'RAUNER WONE',if(value == 'wpre ', 'RAUNER WPRE',if(value == 'wpreb', 'RAUNER WPREB',if(value == 'wqui ', 'RAUNER WQUI',if(value == 'wrab ', 'RAUNER WRAB',if(value == 'wrai ', 'RAUNER WRAI',if(value == 'wraua', 'RAUNER WRAUA',if(value == 'wraub', 'RAUNER WRAUB',if(value == 'wrauc', 'RAUNER WRAUC',if(value == 'wraue', 'RAUNER WRAUE',if(value == 'wrauh', 'RAUNER WRAUH',if(value == 'wraui', 'RAUNER WRAUI',if(value == 'wrauk', 'RAUNER WRAUK',if(value == 'wraup', 'RAUNER WRAUP',if(value == 'wraur', 'RAUNER WRAUR',if(value == 'wraus', 'RAUNER WRAUS',if(value == 'wrauu', 'RAUNER WRAUU',if(value == 'wrauv', 'RAUNER WRAUV',if(value == 'wrauy', 'RAUNER WRAUY',if(value == 'wrauz', 'RAUNER WRAUZ',if(value == 'wred ', 'RAUNER WRED',if(value == 'wrob ', 'RAUNER WROB',if(value == 'wroi ', 'RAUNER WROI',if(value == 'wrol ', 'RAUNER WROL',if(value == 'wrrf ', 'RAUNER WRRF',if(value == 'wrum ', 'RAUNER WRUM',if(value == 'wruz ', 'RAUNER WRUZ',if(value == 'wsan ', 'RAUNER WSAN',if(value == 'wsch ', 'RAUNER WSCH',if(value == 'wscr ', 'RAUNER WSCR',if(value == 'wsef ', 'RAUNER WSEF',if(value == 'wshe ', 'RAUNER WSHE',if(value == 'wsin ', 'RAUNER WSIN',if(value == 'wsis ', 'RAUNER WSIS',if(value == 'wsmj ', 'RAUNER WSMJ',if(value == 'wsta ', 'RAUNER WSTA',if(value == 'wste ', 'RAUNER WSTE',if(value == 'wsteb', 'RAUNER WSTEB',if(value == 'wstv ', 'RAUNER WSTV',if(value == 'wtag ', 'RAUNER WTAG',if(value == 'wtho ', 'RAUNER WTHO',if(value == 'wths ', 'RAUNER WTHS',if(value == 'wtic ', 'RAUNER WTIC',if(value == 'wtom ', 'RAUNER WTOM',if(value == 'wval ', 'RAUNER WVAL',if(value == 'wweb ', 'RAUNER WWEB',if(value == 'wwebb', 'RAUNER WWEBB',if(value == 'wwel ', 'RAUNER WWEL',if(value == 'wwhi ', 'RAUNER WWHI',if(value == 'wwhib', 'RAUNER WWHIB',if(value == 'wwil ', 'RAUNER WWIL',if(value == 'wwlw ', 'RAUNER WWLW',if(value == 'wwlwb', 'RAUNER WWLWB',if(value == 'wwoo ', 'RAUNER WWOO',if(value == 'xxx ', 'EMPTY UNASSIGNED',if(value == 'xxxxx', 'EMPTY UNASSIGNED',if(value == 'yyar ', 'EMPTY UNASSIGNED',if(value == 'yyba ', 'EMPTY UNASSIGNED',if(value == 'yybj ', 'EMPTY UNASSIGNED',if(value == 'yybm ', 'EMPTY UNASSIGNED',if(value == 'yyco ', 'EMPTY UNASSIGNED',if(value == 'yyda ', 'EMPTY UNASSIGNED',if(value == 'yyen ', 'EMPTY UNASSIGNED',if(value == 'yyfe ', 'EMPTY UNASSIGNED',if(value == 'yyke ', 'EMPTY UNASSIGNED',if(value == 'yyld ', 'EMPTY UNASSIGNED',if(value == 'yymf ', 'EMPTY UNASSIGNED',if(value == 'yypa ', 'EMPTY UNASSIGNED',if(value == 'yyra ', 'EMPTY UNASSIGNED',if(value == 'yyst ', 'EMPTY UNASSIGNED',if(value == 'zzdi ', 'EMPTY UNASSIGNED',if(value == 'zzrm ', 'EMPTY UNASSIGNED', value+'*')))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"columnName": "ITEM_LOCATION_CODE",
"expression": "grel:if(value == 'aaaa ', 'BAKER ON ORDER',if(value == 'arfo ', 'SHERMAN FOLIO',if(value == 'arof ', 'SHERMAN OFFICE',if(value == 'arov ', 'SHERMAN OVERSIZE',if(value == 'arrf ', 'SHERMAN REFERENCE',if(value == 'arrs ', 'SHERMAN NOTCATRSRV',if(value == 'arsp ', 'SHERMAN SPECIAL',if(value == 'arspr', 'EMPTY UNASSIGNED',if(value == 'artl ', 'SHERMAN STACKS',if(value == 'axsp ', 'DEPOSITORY DEPOSITORY',if(value == 'axtl ', 'DEPOSITORY DEPOSITORY',if(value == 'baaj ', 'BAKER JAPAN',if(value == 'baao ', 'BAKER JPNOVRSIZE',if(value == 'baaq ', 'BAKER ACQOFFICE',if(value == 'baar ', 'BAKER JPNREF',if(value == 'babc ', 'BAKER CATOFFICE',if(value == 'babr ', 'BAKER BKARTSREF',if(value == 'bacd ', 'BAKER CIRC DESK',if(value == 'bacf ', 'BAKER EAFOLIO',if(value == 'bach ', 'BAKER EASTASIAN',if(value == 'baci ', 'BAKER CIRCOFFICE',if(value == 'baco ', 'BAKER EAOVRSIZE',if(value == 'bacr ', 'BAKER EA REF',if(value == 'baec ', 'BAKER EVANSCLER',if(value == 'baed ', 'BAKER EDOFFICE',if(value == 'bafe ', 'BAKER RESLOCKFER',if(value == 'baff ', 'BAKER REF FOLIO',if(value == 'bafo ', 'BAKER FOLIO',if(value == 'bagd ', 'BAKER GOVDOCS',if(value == 'bagdr', 'JONES CDROM',if(value == 'baha ', 'BAKER HARVARDCOL',if(value == 'bail ', 'BAKER ILLOFFICE',if(value == 'bailm', 'BAKER ILLOFFICEM',if(value == 'bais ', 'BAKER DLTGOFFICE',if(value == 'bajm ', 'JONES JMC',if(value == 'bajma', 'JONES PHONOTAPE',if(value == 'bajmc', 'JONES COMPACTDSC',if(value == 'bajmd', 'JONES JONESMSTR',if(value == 'bajmj', 'EMPTY UNASSIGNED',if(value == 'bajmo', 'JONES BOARDGAME',if(value == 'bajmq', 'JONES DISKETTE',if(value == 'bajmr', 'JONES CDROM',if(value == 'bajms', 'EMPTY UNASSIGNED',if(value == 'bajmv', 'JONES VIDEOTAPE',if(value == 'bajmw', 'JONES VIDEOGAME',if(value == 'bajmx', 'JONES VCD',if(value == 'bajmy', 'JONES DVDROM',if(value == 'bajmz', 'JONES DVD',if(value == 'bajo ', 'JONES OFFICE',if(value == 'bajr ', 'JONES REFERENCE',if(value == 'bake ', 'BAKER TOWERROOMK',if(value == 'bakr ', 'BAKER STACKS',if(value == 'bali ', 'BAKER OFFICE',if(value == 'bamc ', 'BAKER EVANSCIA',if(value == 'bamp ', 'BAKER EVANS',if(value == 'bampk', 'BAKER EVANSVDDSC',if(value == 'bampq', 'BAKER EVANSDSKET',if(value == 'bampr', 'BAKER EVANSCDROM',if(value == 'bampy', 'BAKER EVANSDVDRM',if(value == 'bamr ', 'BAKER EVANSREF',if(value == 'bamrr', 'BAKER EVANSRFCDR',if(value == 'bams ', 'BAKER EVANSSPEC',if(value == 'bana ', 'BAKER NASH',if(value == 'banf ', 'BAKER NASH FOLIO',if(value == 'bano ', 'BAKER NASHOVRSIZ',if(value == 'banp ', 'EMPTY UNASSIGNED',if(value == 'baod ', 'BAKER OLD DART',if(value == 'baov ', 'BAKER OVERSIZE',if(value == 'bapr ', 'BAKER PRESOFFICE',if(value == 'bard ', 'BAKER REF DESK',if(value == 'bare ', 'BAKER REF OFFICE',if(value == 'barf ', 'BAKER REFERENCE',if(value == 'barfm', 'EMPTY UNASSIGNED',if(value == 'barfq', 'EMPTY UNASSIGNED',if(value == 'barfr', 'BAKER CDROM',if(value == 'baro ', 'BAKER REFOVRSIZE',if(value == 'barp ', 'BAKER RESERVE',if(value == 'barph', 'BAKER RESERVEFLM',if(value == 'barpm', 'BAKER RESERVEFCH',if(value == 'barrh', 'BAKER RESPRMFILM',if(value == 'bars ', 'BAKER NOTCATRSRV',if(value == 'bash ', 'BAKER TOWERROOMS',if(value == 'basr ', 'BAKER EASTREADRM',if(value == 'bast ', 'BAKER TOWERROOMT',if(value == 'batc ', 'BAKER CPRBALCONY',if(value == 'batr ', 'BAKER TOWERROOM',if(value == 'bawe ', 'BAKER DEWEY',if(value == 'baxk ', 'BAKER KOREA',if(value == 'baxo ', 'BAKER KOROVERSIZ',if(value == 'baxr ', 'BAKER KORREF',if(value == 'bfjmu', 'JONES FILMSTRG',if(value == 'bxaj ', 'DEPOSITORY DEPOSITORY',if(value == 'bxch ', 'DEPOSITORY DEPOSITORY',if(value == 'bxjm ', 'DEPOSITORY DEPOSITORY',if(value == 'bxjmg', 'DEPOSITORY DEPOSITORY',if(value == 'bxjmh', 'DEPOSITORY DEPOSITORY',if(value == 'bxjmk', 'DEPOSITORY DEPOSITORY',if(value == 'bxjmm', 'DEPOSITORY DEPOSITORY',if(value == 'bxkr ', 'DEPOSITORY DEPOSITORY',if(value == 'bxkrg', 'DEPOSITORY DEPOSITORY',if(value == 'bxkrh', 'DEPOSITORY DEPOSITORY',if(value == 'bxkrj', 'DEPOSITORY DEPOSITORY',if(value == 'bxkrm', 'DEPOSITORY DEPOSITORY',if(value == 'bxmp ', 'DEPOSITORY DEPOSITORY',if(value == 'bxos ', 'DEPOSITORY DEPOSITORY',if(value == 'bxre ', 'DEPOSITORY DEPOSITORY',if(value == 'bxsp ', 'DEPOSITORY DEPOSITORY',if(value == 'bzjmh', 'DEPOSITORY DEPOSITORY',if(value == 'bzkr ', 'DEPOSITORY DEPOSITORY',if(value == 'bzkrg', 'DEPOSITORY DEPOSITORY',if(value == 'coez ', 'BAKER COOK EASY',if(value == 'cook ', 'BAKER COOK',if(value == 'cookt', 'BAKER COOKTHESIS',if(value == 'coov ', 'BAKER COOKOVRSIZ',if(value == 'cxok ', 'DEPOSITORY DEPOSITORY',if(value == 'dana ', 'DANA STACKS',if(value == 'danam', 'EMPTY UNASSIGNED',if(value == 'danas', 'EMPTY UNASSIGNED',if(value == 'danat', 'DANA THESIS',if(value == 'danav', 'EMPTY UNASSIGNED',if(value == 'danaz', 'DANA DVD',if(value == 'daof ', 'EMPTY UNASSIGNED',if(value == 'daos ', 'EMPTY UNASSIGNED',if(value == 'darf ', 'EMPTY UNASSIGNED',if(value == 'dars ', 'DANA NOTCATRSRV',if(value == 'dasp ', 'EMPTY UNASSIGNED',if(value == 'dcres', 'BAKER ONLINE',if(value == 'dxna ', 'DEPOSITORY DEPOSITORY',if(value == 'dzna ', 'DEPOSITORY DEPOSITORY',if(value == 'feld ', 'FELDBERG STACKS',if(value == 'feldc', 'EMPTY UNASSIGNED',if(value == 'feldh', 'EMPTY UNASSIGNED',if(value == 'feldm', 'EMPTY UNASSIGNED',if(value == 'feldt', 'FELDBERG THESIS',if(value == 'feme ', 'FELDBERG MEM',if(value == 'feof ', 'EMPTY UNASSIGNED',if(value == 'fepr ', 'FELDBERG PERMRSRV',if(value == 'ferf ', 'FELDBERG REFERENCE',if(value == 'ferfr', 'FELDBERG REFCDROM',if(value == 'ferfv', 'EMPTY UNASSIGNED',if(value == 'fers ', 'FELDBERG NOTCATRSRV',if(value == 'fesp ', 'EMPTY UNASSIGNED',if(value == 'fxld ', 'DEPOSITORY DEPOSITORY',if(value == 'fxldh', 'DEPOSITORY DEPOSITORY',if(value == 'fxldm', 'DEPOSITORY DEPOSITORY',if(value == 'fxsp ', 'DEPOSITORY DEPOSITORY',if(value == 'krcd ', 'KRESGE DESK',if(value == 'kres ', 'KRESGE STACKS',if(value == 'kresh', 'EMPTY UNASSIGNED',if(value == 'kresi', 'KRESGE ICNGRAPHY',if(value == 'kresr', 'KRESGE CDROM',if(value == 'krest', 'KRESGE THESIS',if(value == 'kresy', 'KRESGE DVDROM',if(value == 'krfo ', 'KRESGE REFOVRSIZE',if(value == 'krmp ', 'KRESGE MAP',if(value == 'krof ', 'EMPTY UNASSIGNED',if(value == 'krov ', 'KRESGE OVERSIZE',if(value == 'krps ', 'KRESGE POPSCI',if(value == 'krrf ', 'KRESGE REFERENCE',if(value == 'krrfr', 'KRESGE REFCDROM',if(value == 'krrs ', 'KRESGE NOTCATRSRV',if(value == 'kxes ', 'DEPOSITORY DEPOSITORY',if(value == 'kxesh', 'DEPOSITORY DEPOSITORY',if(value == 'kxesm', 'DEPOSITORY DEPOSITORY',if(value == 'kzes ', 'DEPOSITORY DEPOSITORY',if(value == 'mfch ', 'MFHSL CONSHEALTH',if(value == 'mfchc', 'MFHSL CHCD',if(value == 'mfchv', 'MFHSL CHVIDTAPE',if(value == 'mfchz', 'MFHSL CHDVD',if(value == 'mflb ', 'MFHSL STACKS',if(value == 'mflbe', 'MFHSL REALIA',if(value == 'mflbr', 'MFHSL CDROM',if(value == 'mflbs', 'MFHSL SLIDE',if(value == 'mflbv', 'MFHSL VIDEOTAPE',if(value == 'mflby', 'MFHSL DVDROM',if(value == 'mflbz', 'MFHSL DVD',if(value == 'mfrf ', 'MFHSL REFERENCE',if(value == 'mxlb ', 'DEPOSITORY DEPOSITORY',if(value == 'none ', 'BAKER ON ORDER',if(value == 'padd ', 'PADDOCK STACKS',if(value == 'padda', 'PADDOCK PHONOTAPE',if(value == 'paddc', 'PADDOCK COMPACTDSC',if(value == 'paddh', 'PADDOCK MICROFILM',if(value == 'paddk', 'PADDOCK VIDEODISC',if(value == 'paddp', 'PADDOCK PHONODISC',if(value == 'paddr', 'PADDOCK CDROM',if(value == 'paddt', 'PADDOCK THESIS',if(value == 'paddv', 'PADDOCK VIDEOTAPE',if(value == 'paddx', 'PADDOCK VCD',if(value == 'paddy', 'PADDOCK DVDROM',if(value == 'paddz', 'PADDOCK DVD',if(value == 'paof ', 'PADDOCK OFFICE',if(value == 'parf ', 'PADDOCK REFERENCE',if(value == 'parfc', 'PADDOCK REFCD',if(value == 'parfr', 'PADDOCK REFCDROM',if(value == 'pars ', 'PADDOCK NOTCATRSRV',if(value == 'pasp ', 'PADDOCK SPECIAL',if(value == 'pxbra', 'DEPOSITORY DEPOSITORY',if(value == 'pxdd ', 'DEPOSITORY DEPOSITORY',if(value == 'pxddp', 'DEPOSITORY DEPOSITORY',if(value == 'rsart', 'SHERMAN COURSERSRV',if(value == 'rsbak', 'BAKER COURSERSRV',if(value == 'rsbue', 'FELDBERG COURSERSRV',if(value == 'rsdan', 'DANA COURSERSRV',if(value == 'rserv', 'BAKER ONLINE',if(value == 'rshsl', 'MFHSL COURSERSRV',if(value == 'rsjmc', 'JONES COURSERSRV',if(value == 'rsmus', 'PADDOCK COURSERSRV',if(value == 'rsphs', 'KRESGE COURSERSRV',if(value == 'rspro', 'BAKER ONRESPRM',if(value == 'rsstf', 'BAKER RESPRM',if(value == 'uncat', 'EMPTY UNASSIGNED',if(value == 'w1926', 'RAUNER W1926',if(value == 'walu ', 'RAUNER WALU',if(value == 'wbal ', 'RAUNER WBAL',if(value == 'wbib ', 'RAUNER WBIB',if(value == 'wbie ', 'RAUNER WBIE',if(value == 'wbin ', 'RAUNER WBIN',if(value == 'wblu ', 'RAUNER WBLU',if(value == 'wbrl ', 'RAUNER WBRL',if(value == 'wbro ', 'RAUNER WBRO',if(value == 'wbry ', 'RAUNER WBRY',if(value == 'wbur ', 'RAUNER WBUR',if(value == 'wcad ', 'RAUNER WCAD',if(value == 'wcadb', 'RAUNER WCADB',if(value == 'wcal ', 'RAUNER WCAL',if(value == 'wcan ', 'RAUNER WCAN',if(value == 'wchg ', 'RAUNER WCHG',if(value == 'wchn ', 'RAUNER WCHN',if(value == 'wchs ', 'RAUNER WCHS',if(value == 'wchsb', 'RAUNER WCHSB',if(value == 'wcng ', 'RAUNER WCNG',if(value == 'wcon ', 'RAUNER WCON',if(value == 'wcra ', 'RAUNER WCRA',if(value == 'wcug ', 'RAUNER WCUG',if(value == 'wcus ', 'RAUNER WCUS',if(value == 'wdca ', 'RAUNER WDCA',if(value == 'wdch ', 'RAUNER WDCH',if(value == 'wdchb', 'RAUNER WDCHB',if(value == 'wdcl ', 'RAUNER WDCL',if(value == 'wdcm ', 'RAUNER WDCM',if(value == 'wdcn ', 'RAUNER WDCN',if(value == 'wdco ', 'RAUNER WDCO',if(value == 'wdct ', 'RAUNER WDCT',if(value == 'wdcu ', 'RAUNER WDCU',if(value == 'wdew ', 'RAUNER WDEW',if(value == 'wdim ', 'RAUNER WDIM',if(value == 'wdog ', 'RAUNER WDOG',if(value == 'wdol ', 'RAUNER WDOL',if(value == 'webe ', 'RAUNER WEBE',if(value == 'webeb', 'RAUNER WEBEB',if(value == 'wedt ', 'RAUNER WEDT',if(value == 'wfie ', 'RAUNER WFIE',if(value == 'wfro ', 'RAUNER WFRO',if(value == 'wfrob', 'RAUNER WFROB',if(value == 'wgar ', 'RAUNER WGAR',if(value == 'wgil ', 'RAUNER WGIL',if(value == 'wgra ', 'RAUNER WGRA',if(value == 'whew ', 'RAUNER WHEW',if(value == 'whic ', 'RAUNER WHIC',if(value == 'whil ', 'RAUNER WHIL',if(value == 'whot ', 'RAUNER WHOT',if(value == 'whud ', 'RAUNER WHUD',if(value == 'whun ', 'RAUNER WHUN',if(value == 'whux ', 'RAUNER WHUX',if(value == 'will ', 'RAUNER WILL',if(value == 'willb', 'RAUNER WILLB',if(value == 'winc ', 'RAUNER WINC',if(value == 'withd', 'BAKER WITHDRAWN',if(value == 'wlan ', 'RAUNER WLAN',if(value == 'wlanb', 'RAUNER WLANB',if(value == 'wlaw ', 'RAUNER WLAW',if(value == 'wlin ', 'RAUNER WLIN',if(value == 'wlog ', 'RAUNER WLOG',if(value == 'wlon ', 'RAUNER WLON',if(value == 'wmac ', 'RAUNER WMAC',if(value == 'wmaf ', 'RAUNER WMAF',if(value == 'wman ', 'RAUNER WMAN',if(value == 'wmas ', 'RAUNER WMAS',if(value == 'wmcg ', 'RAUNER WMCG',if(value == 'wmeb ', 'RAUNER WMEB',if(value == 'wmebb', 'RAUNER WMEBB',if(value == 'wmel ', 'RAUNER WMEL',if(value == 'wmen ', 'RAUNER WMEN',if(value == 'wmfr ', 'RAUNER WMFR',if(value == 'wmhi ', 'RAUNER WMHI',if(value == 'wmin ', 'RAUNER WMIN',if(value == 'wmmc ', 'RAUNER WMMC',if(value == 'wmnc ', 'RAUNER WMNC',if(value == 'wmru ', 'RAUNER WMRU',if(value == 'wmst ', 'RAUNER WMST',if(value == 'wmwe ', 'RAUNER WMWE',if(value == 'wnal ', 'RAUNER WNAL',if(value == 'wnam ', 'RAUNER WNAM',if(value == 'wnan ', 'RAUNER WNAN',if(value == 'wnas ', 'RAUNER WNAS',if(value == 'wnba ', 'RAUNER WNBA',if(value == 'wnbo ', 'RAUNER WNBO',if(value == 'wnbr ', 'RAUNER WNBR',if(value == 'wnca ', 'RAUNER WNCA',if(value == 'wnch ', 'RAUNER WNCH',if(value == 'wncl ', 'RAUNER WNCL',if(value == 'wncn ', 'RAUNER WNCN',if(value == 'wnco ', 'RAUNER WNCO',if(value == 'wncr ', 'RAUNER WNCR',if(value == 'wnde ', 'RAUNER WNDE',if(value == 'wndn ', 'RAUNER WNDN',if(value == 'wndo ', 'RAUNER WNDO',if(value == 'wndu ', 'RAUNER WNDU',if(value == 'wnea ', 'RAUNER WNEA',if(value == 'wneb ', 'RAUNER WNEB',if(value == 'wnec ', 'RAUNER WNEC',if(value == 'wnen ', 'RAUNER WNEN',if(value == 'wnep ', 'RAUNER WNEP',if(value == 'wnex ', 'RAUNER WNEX',if(value == 'wnfa ', 'RAUNER WNFA',if(value == 'wnff ', 'RAUNER WNFF',if(value == 'wnfr ', 'RAUNER WNFR',if(value == 'wnfs ', 'RAUNER WNFS',if(value == 'wnfz ', 'RAUNER WNFZ',if(value == 'wngf ', 'RAUNER WNGF',if(value == 'wngl ', 'RAUNER WNGL',if(value == 'wngo ', 'RAUNER WNGO',if(value == 'wngr ', 'RAUNER WNGR',if(value == 'wngt ', 'RAUNER WNGT',if(value == 'wnha ', 'RAUNER WNHA',if(value == 'wnhf ', 'RAUNER WNHF',if(value == 'wnhi ', 'RAUNER WNHI',if(value == 'wnhn ', 'RAUNER WNHN',if(value == 'wnho ', 'RAUNER WNHO',if(value == 'wnhv ', 'RAUNER WNHV',if(value == 'wnja ', 'RAUNER WNJA',if(value == 'wnke ', 'RAUNER WNKE',if(value == 'wnlc ', 'RAUNER WNLC',if(value == 'wnle ', 'RAUNER WNLE',if(value == 'wnli ', 'RAUNER WNLI',if(value == 'wnlk ', 'RAUNER WNLK',if(value == 'wnln ', 'RAUNER WNLN',if(value == 'wnma ', 'RAUNER WNMA',if(value == 'wnmb ', 'RAUNER WNMB',if(value == 'wnmd ', 'RAUNER WNMD',if(value == 'wnmi ', 'RAUNER WNMI',if(value == 'wnml ', 'RAUNER WNML',if(value == 'wnmr ', 'RAUNER WNMR',if(value == 'wnna ', 'RAUNER WNNA',if(value == 'wnne ', 'RAUNER WNNE',if(value == 'wnnf ', 'RAUNER WNNF',if(value == 'wnnh ', 'RAUNER WNNH',if(value == 'wnni ', 'RAUNER WNNI',if(value == 'wnpl ', 'RAUNER WNPL',if(value == 'wnpm ', 'RAUNER WNPM',if(value == 'wnpn ', 'RAUNER WNPN',if(value == 'wnpo ', 'RAUNER WNPO',if(value == 'wnpt ', 'RAUNER WNPT',if(value == 'wnro ', 'RAUNER WNRO',if(value == 'wnru ', 'RAUNER WNRU',if(value == 'wnsd ', 'RAUNER WNSD',if(value == 'wnsh ', 'RAUNER WNSH',if(value == 'wnso ', 'RAUNER WNSO',if(value == 'wnsp ', 'RAUNER WNSP',if(value == 'wnsr ', 'RAUNER WNSR',if(value == 'wnst ', 'RAUNER WNST',if(value == 'wnsu ', 'RAUNER WNSU',if(value == 'wnsv ', 'RAUNER WNSV',if(value == 'wnsw ', 'RAUNER WNSW',if(value == 'wnwc ', 'RAUNER WNWC',if(value == 'wnwd ', 'RAUNER WNWD',if(value == 'wnwe ', 'RAUNER WNWE',if(value == 'wnwf ', 'RAUNER WNWF',if(value == 'wnwh ', 'RAUNER WNWH',if(value == 'wnwl ', 'RAUNER WNWL',if(value == 'wnwn ', 'RAUNER WNWN',if(value == 'wnwr ', 'RAUNER WNWR',if(value == 'wnwv ', 'RAUNER WNWV',if(value == 'wocc ', 'RAUNER WOCC',if(value == 'woli ', 'RAUNER WOLI',if(value == 'wone ', 'RAUNER WONE',if(value == 'wpre ', 'RAUNER WPRE',if(value == 'wpreb', 'RAUNER WPREB',if(value == 'wqui ', 'RAUNER WQUI',if(value == 'wrab ', 'RAUNER WRAB',if(value == 'wrai ', 'RAUNER WRAI',if(value == 'wraua', 'RAUNER WRAUA',if(value == 'wraub', 'RAUNER WRAUB',if(value == 'wrauc', 'RAUNER WRAUC',if(value == 'wraue', 'RAUNER WRAUE',if(value == 'wrauh', 'RAUNER WRAUH',if(value == 'wraui', 'RAUNER WRAUI',if(value == 'wrauk', 'RAUNER WRAUK',if(value == 'wraup', 'RAUNER WRAUP',if(value == 'wraur', 'RAUNER WRAUR',if(value == 'wraus', 'RAUNER WRAUS',if(value == 'wrauu', 'RAUNER WRAUU',if(value == 'wrauv', 'RAUNER WRAUV',if(value == 'wrauy', 'RAUNER WRAUY',if(value == 'wrauz', 'RAUNER WRAUZ',if(value == 'wred ', 'RAUNER WRED',if(value == 'wrob ', 'RAUNER WROB',if(value == 'wroi ', 'RAUNER WROI',if(value == 'wrol ', 'RAUNER WROL',if(value == 'wrrf ', 'RAUNER WRRF',if(value == 'wrum ', 'RAUNER WRUM',if(value == 'wruz ', 'RAUNER WRUZ',if(value == 'wsan ', 'RAUNER WSAN',if(value == 'wsch ', 'RAUNER WSCH',if(value == 'wscr ', 'RAUNER WSCR',if(value == 'wsef ', 'RAUNER WSEF',if(value == 'wshe ', 'RAUNER WSHE',if(value == 'wsin ', 'RAUNER WSIN',if(value == 'wsis ', 'RAUNER WSIS',if(value == 'wsmj ', 'RAUNER WSMJ',if(value == 'wsta ', 'RAUNER WSTA',if(value == 'wste ', 'RAUNER WSTE',if(value == 'wsteb', 'RAUNER WSTEB',if(value == 'wstv ', 'RAUNER WSTV',if(value == 'wtag ', 'RAUNER WTAG',if(value == 'wtho ', 'RAUNER WTHO',if(value == 'wths ', 'RAUNER WTHS',if(value == 'wtic ', 'RAUNER WTIC',if(value == 'wtom ', 'RAUNER WTOM',if(value == 'wval ', 'RAUNER WVAL',if(value == 'wweb ', 'RAUNER WWEB',if(value == 'wwebb', 'RAUNER WWEBB',if(value == 'wwel ', 'RAUNER WWEL',if(value == 'wwhi ', 'RAUNER WWHI',if(value == 'wwhib', 'RAUNER WWHIB',if(value == 'wwil ', 'RAUNER WWIL',if(value == 'wwlw ', 'RAUNER WWLW',if(value == 'wwlwb', 'RAUNER WWLWB',if(value == 'wwoo ', 'RAUNER WWOO',if(value == 'xxx ', 'EMPTY UNASSIGNED',if(value == 'xxxxx', 'EMPTY UNASSIGNED',if(value == 'yyar ', 'EMPTY UNASSIGNED',if(value == 'yyba ', 'EMPTY UNASSIGNED',if(value == 'yybj ', 'EMPTY UNASSIGNED',if(value == 'yybm ', 'EMPTY UNASSIGNED',if(value == 'yyco ', 'EMPTY UNASSIGNED',if(value == 'yyda ', 'EMPTY UNASSIGNED',if(value == 'yyen ', 'EMPTY UNASSIGNED',if(value == 'yyfe ', 'EMPTY UNASSIGNED',if(value == 'yyke ', 'EMPTY UNASSIGNED',if(value == 'yyld ', 'EMPTY UNASSIGNED',if(value == 'yymf ', 'EMPTY UNASSIGNED',if(value == 'yypa ', 'EMPTY UNASSIGNED',if(value == 'yyra ', 'EMPTY UNASSIGNED',if(value == 'yyst ', 'EMPTY UNASSIGNED',if(value == 'zzdi ', 'EMPTY UNASSIGNED',if(value == 'zzrm ', 'EMPTY UNASSIGNED', value+'*')))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column PTYPE_CODE using expression grel:if(value == '0', 'Undergrad',if(value == '1', 'Grad student',if(value == '2', 'Faculty',if(value == '3', 'Faculty',if(value == '4', 'Faculty',if(value == '5', 'Staff',if(value == '6', 'Staff',if(value == '7', 'Non-Dartmouth',if(value == '8', 'Non-Dartmouth',if(value == '9', 'Non-Dartmouth',if(value == '10', 'Reserve',if(value == '11', 'Library Display',if(value == '12', 'Special Program',if(value == '13', 'Storage Visitor Account',if(value == '16', 'Unregistered user',if(value == '17', 'Research Assist.',if(value == '18', 'Interlibrary loan',if(value == '21', 'Library Department',if(value == '22', 'Retired Staff',if(value == '24', 'Delinquent patron',if(value == '25', 'Courtesy',if(value == '26', 'Music Grad Student',if(value == '27', 'Guest user',if(value == '29', 'Preservation Services',if(value == '32', 'GB-Special',if(value == '33', 'OPAC features test',if(value == '34', 'Borrow Direct',if(value == '36', 'DHMC AP-II/Service',if(value == '37', 'test student',if(value == '38', 'Student Plus',if(value == '39', 'Onsite BD',if(value == '253', 'Course Reserves Ptype for Recall',if(value == '254', 'Test Patron',if(value == '255', 'ERROR--Pls. update!', value + '*'))))))))))))))))))))))))))))))))))",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"columnName": "PTYPE_CODE",
"expression": "grel:if(value == '0', 'Undergrad',if(value == '1', 'Grad student',if(value == '2', 'Faculty',if(value == '3', 'Faculty',if(value == '4', 'Faculty',if(value == '5', 'Staff',if(value == '6', 'Staff',if(value == '7', 'Non-Dartmouth',if(value == '8', 'Non-Dartmouth',if(value == '9', 'Non-Dartmouth',if(value == '10', 'Reserve',if(value == '11', 'Library Display',if(value == '12', 'Special Program',if(value == '13', 'Storage Visitor Account',if(value == '16', 'Unregistered user',if(value == '17', 'Research Assist.',if(value == '18', 'Interlibrary loan',if(value == '21', 'Library Department',if(value == '22', 'Retired Staff',if(value == '24', 'Delinquent patron',if(value == '25', 'Courtesy',if(value == '26', 'Music Grad Student',if(value == '27', 'Guest user',if(value == '29', 'Preservation Services',if(value == '32', 'GB-Special',if(value == '33', 'OPAC features test',if(value == '34', 'Borrow Direct',if(value == '36', 'DHMC AP-II/Service',if(value == '37', 'test student',if(value == '38', 'Student Plus',if(value == '39', 'Onsite BD',if(value == '253', 'Course Reserves Ptype for Recall',if(value == '254', 'Test Patron',if(value == '255', 'ERROR--Pls. update!', value + '*'))))))))))))))))))))))))))))))))))",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/column-rename",
"description": "Rename column PCODE1 to Description",
"oldColumnName": "PCODE1",
"newColumnName": "Description"
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column Description using expression grel:if(value == '-', 'Blank Value',if(value == 'a', 'TEST USER',if(value == 'b', 'COMMUNITY',if(value == 'c', 'COURTESY',if(value == 'd', 'DELETE',if(value == 'e', 'THAYER STUDEN',if(value == 'f', 'DELINQ-GRAD',if(value == 'g', 'GRADUATING',if(value == 'h', 'DHMC',if(value == 'k', 'VIS. SCHOLAR',if(value == 'l', 'LIBR PROCESS',if(value == 'm', 'MED STUDENT',if(value == 'o', 'KAPLAN STUDENT',if(value == 'q', 'TEMPORARY REC',if(value == 'r', 'EMERITUS/RET.',if(value == 's', 'SUMMER PROG.',if(value == 't', 'TUCK STUDENT',if(value == 'v', 'VIS/EXCH STU',if(value == 'x', 'DART COLL STU',if(value == 'z', 'ERROR RECORD',if(value == 'p', 'DHMC RES/FELLOW', value + '*')))))))))))))))))))))",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"columnName": "Description",
"expression": "grel:if(value == '-', 'Blank Value',if(value == 'a', 'TEST USER',if(value == 'b', 'COMMUNITY',if(value == 'c', 'COURTESY',if(value == 'd', 'DELETE',if(value == 'e', 'THAYER STUDEN',if(value == 'f', 'DELINQ-GRAD',if(value == 'g', 'GRADUATING',if(value == 'h', 'DHMC',if(value == 'k', 'VIS. SCHOLAR',if(value == 'l', 'LIBR PROCESS',if(value == 'm', 'MED STUDENT',if(value == 'o', 'KAPLAN STUDENT',if(value == 'q', 'TEMPORARY REC',if(value == 'r', 'EMERITUS/RET.',if(value == 's', 'SUMMER PROG.',if(value == 't', 'TUCK STUDENT',if(value == 'v', 'VIS/EXCH STU',if(value == 'x', 'DART COLL STU',if(value == 'z', 'ERROR RECORD',if(value == 'p', 'DHMC RES/FELLOW', value + '*')))))))))))))))))))))",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/column-rename",
"description": "Rename column PCODE3 to Department/affiliation",
"oldColumnName": "PCODE3",
"newColumnName": "Department/affiliation"
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column Department/affiliation using expression grel:if(value == '1', 'AFRICAN & AFRO-AM',if(value == '2', 'ALUMNI COLLEGE',if(value == '3', 'ANATOMY',if(value == '4', 'ANESTHESIOLOGY',if(value == '5', 'ANTHROPOLOGY',if(value == '6', 'ART HISTORY',if(value == '7', 'ASIAN STUDIES',if(value == '8', 'BIOCHEMISTRY',if(value == '9', 'BIOLOGY',if(value == '10', ' CANE',if(value == '11', ' CHEMISTRY',if(value == '12', ' CLASSICS',if(value == '13', ' CLIPP',if(value == '14', ' BIOMED-SPECIAL',if(value == '15', ' COMM & FAM MED',if(value == '16', ' COMP & INFO SCI',if(value == '17', ' COMPARATIVE LIT',if(value == '18', ' CLERGY',if(value == '19', ' DART-COLL-ADMIN',if(value == '20', ' INSTITUE FOR WRITING/RHETORIC',if(value == '21', ' DARTMOUTH INST.',if(value == '22', ' MHMH-GENERAL',if(value == '23', ' MHMH-NURSE',if(value == '24', ' DMS-GENERAL',if(value == '25', ' DMS-NURSE',if(value == '26', ' Pluralism and Leadership (OPAL)',if(value == '27', ' DRAMA & FILM STUD',if(value == '28', ' EARTH SCIENCES',if(value == '29', ' ECONOMICS',if(value == '30', ' EDUCATION',if(value == '31', ' ELECTRON-MICROSC',if(value == '32', ' SCT',if(value == '33', ' EMPLOYEE FAMILY',if(value == '34', ' ENGINEERING SCI.',if(value == '35', ' ENGLISH',if(value == '36', ' ENVIRON. STUD.',if(value == '37', ' EVALUATIVE CLINICAL SCIENCES',if(value == '38', ' FORENSIC UNION',if(value == '39', ' FRENCH & ITALIAN',if(value == '40', ' GEOGRAPHY',if(value == '41', ' GERMAN',if(value == '42', ' GOVERNMENT',if(value == '43', ' HIGH SCHOOL',if(value == '44', ' HISTORY',if(value == '45', ' H-CLIN-GENERAL',if(value == '46', ' H-CLIN-NURSE',if(value == '47', ' HOOD MUSEUM',if(value == '48', ' HOPKINS CENTER',if(value == '49', ' HUMANITIES',if(value == '50', ' OSHER',if(value == '51', ' LATIN AM & CARRIB',if(value == '52', ' LIBERAL STUDIES',if(value == '53', ' LIBRARY',if(value == '54', ' LINGUISTICS',if(value == '55', ' MATH',if(value == '56', ' MATH & SOC. SCI.',if(value == '57', ' MEDICINE',if(value == '58', ' MICROBIOLOGY (DMS)',if(value == '59', ' MUSIC',if(value == '60', ' Counseling/Human Development',if(value == '61', ' NATIVE AMER. STUD.',if(value == '62', ' NEH',if(value == '63', ' ACAD-PROG-MISC',if(value == '64', ' OBSTET & GYNECOL',if(value == '65', ' PATHOLOGY (DMS)',if(value == '66', ' PEDIATRICS',if(value == '67', ' PHARM & TOXICOL',if(value == '68', ' Quantitative Biomedical Sciences',if(value == '69', ' PHILOSOPHY',if(value == '70', ' PHYSICS & ASTRON',if(value == '71', ' PHYSIOLOGY (DMS)',if(value == '72', ' PROJECT CORK',if(value == '74', ' PSYCHIATRY',if(value == '75', ' PSYCHOLOGY',if(value == '76', ' RADIOLOGY',if(value == '77', ' RELIGION',if(value == '78', ' RLG',if(value == '79', ' RUSSIAN',if(value == '80', ' SOCIOLOGY',if(value == '82', ' SPANISH & PORT.',if(value == '83', ' SPECIAL',if(value == '84', ' SPEECH',if(value == '85', ' STUDIO ART',if(value == '86', ' SURGERY',if(value == '87', ' THAYER SCHOOL',if(value == '88', ' TUCK SCHOOL',if(value == '89', ' VA-WRJ',if(value == '91', ' VISUAL STUDIES',if(value == '92', ' WOMEN\\'S STUDIES',if(value == '93', ' ALUMNI',if(value == '96', ' DEBATE',if(value == '97', ' THAYER-ASSOC',if(value == '98', ' CRREL',if(value == '99', ' DANA/COLLAB',if(value == '100', 'LEADER. ALLIANCE',if(value == '101', 'LANGUAGE OUTREACH',if(value == '102', 'RASSIAS FOUNDATION',if(value == '103', 'NEW DIRECTIONS',if(value == '104', 'STUDENT EMPLOYEE',if(value == '105', 'NEGNEC',if(value == '112', 'NORRIS COTTON CANCER CENTER',if(value == '113', 'ASIAN & MIDDLE EASTERN LANG.',if(value == '114', 'SPEC-PROG-ADMIN',if(value == '115', 'DART-COLL-MISC',if(value == '116', 'DC-ATHLETICS',if(value == '117', 'ETHICS INSTITUTE',if(value == '118', 'RUGG FELLOW',if(value == '119', 'HUMANITIES INSTITUTE (SUMMER)',if(value == '120', 'FRENCH CULTURAL STUDIES',if(value == '121', 'RETIRED',if(value == '122', 'NEUROLOGY',if(value == '123', 'ORTHOPAEDICS',if(value == '124', 'Film + Television Studies',if(value == '130', 'Jewish Studies',if(value == '131', 'Writing Program',if(value == '132', 'HEALTH CARE DELIVERY SCIENCE', if(value == '0', 'None', value + '*')))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"columnName": "Department/affiliation",
"expression": "grel:if(value == '1', 'AFRICAN & AFRO-AM',if(value == '2', 'ALUMNI COLLEGE',if(value == '3', 'ANATOMY',if(value == '4', 'ANESTHESIOLOGY',if(value == '5', 'ANTHROPOLOGY',if(value == '6', 'ART HISTORY',if(value == '7', 'ASIAN STUDIES',if(value == '8', 'BIOCHEMISTRY',if(value == '9', 'BIOLOGY',if(value == '10', ' CANE',if(value == '11', ' CHEMISTRY',if(value == '12', ' CLASSICS',if(value == '13', ' CLIPP',if(value == '14', ' BIOMED-SPECIAL',if(value == '15', ' COMM & FAM MED',if(value == '16', ' COMP & INFO SCI',if(value == '17', ' COMPARATIVE LIT',if(value == '18', ' CLERGY',if(value == '19', ' DART-COLL-ADMIN',if(value == '20', ' INSTITUE FOR WRITING/RHETORIC',if(value == '21', ' DARTMOUTH INST.',if(value == '22', ' MHMH-GENERAL',if(value == '23', ' MHMH-NURSE',if(value == '24', ' DMS-GENERAL',if(value == '25', ' DMS-NURSE',if(value == '26', ' Pluralism and Leadership (OPAL)',if(value == '27', ' DRAMA & FILM STUD',if(value == '28', ' EARTH SCIENCES',if(value == '29', ' ECONOMICS',if(value == '30', ' EDUCATION',if(value == '31', ' ELECTRON-MICROSC',if(value == '32', ' SCT',if(value == '33', ' EMPLOYEE FAMILY',if(value == '34', ' ENGINEERING SCI.',if(value == '35', ' ENGLISH',if(value == '36', ' ENVIRON. STUD.',if(value == '37', ' EVALUATIVE CLINICAL SCIENCES',if(value == '38', ' FORENSIC UNION',if(value == '39', ' FRENCH & ITALIAN',if(value == '40', ' GEOGRAPHY',if(value == '41', ' GERMAN',if(value == '42', ' GOVERNMENT',if(value == '43', ' HIGH SCHOOL',if(value == '44', ' HISTORY',if(value == '45', ' H-CLIN-GENERAL',if(value == '46', ' H-CLIN-NURSE',if(value == '47', ' HOOD MUSEUM',if(value == '48', ' HOPKINS CENTER',if(value == '49', ' HUMANITIES',if(value == '50', ' OSHER',if(value == '51', ' LATIN AM & CARRIB',if(value == '52', ' LIBERAL STUDIES',if(value == '53', ' LIBRARY',if(value == '54', ' LINGUISTICS',if(value == '55', ' MATH',if(value == '56', ' MATH & SOC. SCI.',if(value == '57', ' MEDICINE',if(value == '58', ' MICROBIOLOGY (DMS)',if(value == '59', ' MUSIC',if(value == '60', ' Counseling/Human Development',if(value == '61', ' NATIVE AMER. STUD.',if(value == '62', ' NEH',if(value == '63', ' ACAD-PROG-MISC',if(value == '64', ' OBSTET & GYNECOL',if(value == '65', ' PATHOLOGY (DMS)',if(value == '66', ' PEDIATRICS',if(value == '67', ' PHARM & TOXICOL',if(value == '68', ' Quantitative Biomedical Sciences',if(value == '69', ' PHILOSOPHY',if(value == '70', ' PHYSICS & ASTRON',if(value == '71', ' PHYSIOLOGY (DMS)',if(value == '72', ' PROJECT CORK',if(value == '74', ' PSYCHIATRY',if(value == '75', ' PSYCHOLOGY',if(value == '76', ' RADIOLOGY',if(value == '77', ' RELIGION',if(value == '78', ' RLG',if(value == '79', ' RUSSIAN',if(value == '80', ' SOCIOLOGY',if(value == '82', ' SPANISH & PORT.',if(value == '83', ' SPECIAL',if(value == '84', ' SPEECH',if(value == '85', ' STUDIO ART',if(value == '86', ' SURGERY',if(value == '87', ' THAYER SCHOOL',if(value == '88', ' TUCK SCHOOL',if(value == '89', ' VA-WRJ',if(value == '91', ' VISUAL STUDIES',if(value == '92', ' WOMEN\\'S STUDIES',if(value == '93', ' ALUMNI',if(value == '96', ' DEBATE',if(value == '97', ' THAYER-ASSOC',if(value == '98', ' CRREL',if(value == '99', ' DANA/COLLAB',if(value == '100', 'LEADER. ALLIANCE',if(value == '101', 'LANGUAGE OUTREACH',if(value == '102', 'RASSIAS FOUNDATION',if(value == '103', 'NEW DIRECTIONS',if(value == '104', 'STUDENT EMPLOYEE',if(value == '105', 'NEGNEC',if(value == '112', 'NORRIS COTTON CANCER CENTER',if(value == '113', 'ASIAN & MIDDLE EASTERN LANG.',if(value == '114', 'SPEC-PROG-ADMIN',if(value == '115', 'DART-COLL-MISC',if(value == '116', 'DC-ATHLETICS',if(value == '117', 'ETHICS INSTITUTE',if(value == '118', 'RUGG FELLOW',if(value == '119', 'HUMANITIES INSTITUTE (SUMMER)',if(value == '120', 'FRENCH CULTURAL STUDIES',if(value == '121', 'RETIRED',if(value == '122', 'NEUROLOGY',if(value == '123', 'ORTHOPAEDICS',if(value == '124', 'Film + Television Studies',if(value == '130', 'Jewish Studies',if(value == '131', 'Writing Program',if(value == '132', 'HEALTH CARE DELIVERY SCIENCE', if(value == '0', 'None', value + '*')))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/column-rename",
"description": "Rename column PCODE2 to III Stat Cat",
"oldColumnName": "PCODE2",
"newColumnName": "III Stat Cat"
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column III Stat Cat using expression grel:if(value == 'a', 'API',if(value == 'd', 'BATCH DELETE',if(value == 'f', 'FACULTY',if(value == 'g', 'GRADUATE',if(value == 'i', 'ILL',if(value == 'n', 'NON-DARTMOUTH',if(value == 's', 'STAFF',if(value == 'u', 'UNDERGRAD',if(value == 'x', 'INTERNAL LIB ACCT',if(value == '1', 'BLANK', value + '*'))))))))))",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"columnName": "III Stat Cat",
"expression": "grel:if(value == 'a', 'API',if(value == 'd', 'BATCH DELETE',if(value == 'f', 'FACULTY',if(value == 'g', 'GRADUATE',if(value == 'i', 'ILL',if(value == 'n', 'NON-DARTMOUTH',if(value == 's', 'STAFF',if(value == 'u', 'UNDERGRAD',if(value == 'x', 'INTERNAL LIB ACCT',if(value == '1', 'BLANK', value + '*'))))))))))",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
}
]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment