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