Alteryx Designer

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

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

Highlighted
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

Highlighted
Alteryx Certified Partner

Hi @Saadshj

 

Check out the Concatenate function of the Summarize tool:

2.1.PNG 

2.2.PNG

Highlighted
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

 

Highlighted
Alteryx Certified Partner

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

2.3.PNG 

Highlighted
5 - Atom

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

Labels