Early bird tickets for Inspire 2023 are now available! Discounted pricing closes on January 31st. Save your spot!

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer and Intelligence Suite.

Using the IN function to function for a string of room numbers and map to a cost center

lynettejackson
7 - Meteor

I'm interested in finding out the best method to program a string of room numbers so they can report cost center data.  

 

IN [Room]Cost Center Read Out
201-02','201-04','201-16','201-18','201-24','201-26','201-28','201-36','RM201.1','RM201.2','RM201.3'LRL MedChem-100A93A
201-08','201-10','201-12','201-14','201-20','201-22','201-32','201-34'RNA Therapeutics-1000081
301-02'',301-08','301-12','301-14','301-16','301-22','301-26','301-28','301-34','301-36',LRL MedChem-100A93A
301-24Structural Computational Sciences-100AF94
104-02','104-06','104-10','104-12','104-14','104-16','104-22,'104-24','104-26','104-28','104-34','104-36','RM104.1,'RM104.2',RM1.3'Protein Discover Research-100A625
2 REPLIES 2
SPetrie
11 - Bolide

I think a summarize is all you need. Group it by the Cost center and concatenate the Space Number Table Number column.

Assuming you are wanting the single quote around each item, you just need to setup the concatenate options to add them in.

 

SPetrie_2-1660158320842.png

 

lynettejackson
7 - Meteor

Ok,  Let me try your recommendation.

Labels