Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
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