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

Parsing to Rows for Multiple Columns using Text-To-Column Tool

hisyam10
7 - Meteor

Hello and Good Day All. How do I parse to rows using Text-to-Column tool but for multiple fields?
The structure is almost the same but currently, I have around 141 columns to parse to rows. I do not want to put 141 Text-to-Column tools just to parse each of the columns.

 

Attached is the workflow and data. I appreciate your help with this.

 

Thank you very much.

5 REPLIES 5
paulfound
11 - Bolide

Hi @hisyam10 

 

PaulFound_0-1600931413835.png

I have added a row id per page so that when you ross tab you can group by.

atcodedog05
22 - Nova
22 - Nova

Hi @hisyam10 ,

 

I think i get what you are trying to achieve.

There is a workflow. It generates Group ID (unique to Page and not overall)

atcodedog05_0-1600931928412.png

 

 Output.

atcodedog05_1-1600931981735.png

 

Hope this helps.

 

Please mark my post as solution if it helps.

hisyam10
7 - Meteor

Thank you very much @paulfound ! You just saved my life. I appreciate it very much.

hisyam10
7 - Meteor

Hi @atcodedog05 I tried your workflow and it works fantastic. Thank you very much ! I really appreciate it.

atcodedog05
22 - Nova
22 - Nova

Hi @hisyam10 

 

Happy to help : )

Labels