Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Combine multiple Column single row .

razzy
8 - Asteroid

Hi All,

I am trying to combine multiple columns into a single row to be used in an sql query, the number of column is about a thousand i will need to seperae each of the column when combine with a comma and quotes on each out put.

Desired From worksheet attached

"e228","d6de","cc0d","f63d", etc.....

Any help will be appreciated.

attached is the excel document.

Thanks

5 REPLIES 5
messi007
15 - Aurora
15 - Aurora

@razzy,

 

Please see below :

 

messi007_0-1654016085628.png

 

Attached the workflow,

Regards

IraWatt
17 - Castor
17 - Castor

Hey @razzy,

is this something your looking for:

IraWatt_0-1654016108322.png

IraWatt_1-1654016129384.png

 

 

razzy
8 - Asteroid

Thank you for helping the solution worked

razzy
8 - Asteroid

Thank you this was perfect

messi007
15 - Aurora
15 - Aurora

@razzy,

 

Happy to help!

 

Regards,

LogoPrime.png

Labels