6/17/21: We have completed maintenance for the Search functionality on the Community. If you are seeing any issues, please try to clear your cache first. If the issue persists please email Community@alteryx.com

Alteryx Designer Discussions

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

Transpose to a single cell starting with ' and separated by ,

Saadshj
5 - Atom

Hello,

 

Probably a basic question but i am very lost. I have a list as follows 

 

Order #s

12345

23456

67891

The number of these rows (=orders is variable, 3 as an example here). i want to have the following results 

 

'12345','23456','67891' 

 

Thanks in advance guiding me in the right direction

4 REPLIES 4
Aaron_Harter
11 - Bolide

Hi @Saadshj

 

Check out the Concatenate function of the Summarize tool:

2.1.PNG 

2.2.PNG

AshleyL
Alteryx
Alteryx

Hey @Saadshj 

 

Going off of @Aaron_Harter -- if you want quotes around each order number, I would use a formula tool instead of a Select tool with the formula: "'" + ToString([Order#]) + "'" to create a new column to use in the summarize tool!

 

AshleyL_0-1587569633059.png

 

Aaron_Harter
11 - Bolide

@Saadshj - updating the Separator condition to include the extra quote between each item:

2.3.PNG 

Saadshj
5 - Atom

Brilliant, works perfectly. thank you guys, very much appreciated

Labels