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

Turning one column into different columns

Alexandra_Pops
6 - Meteoroid

Hi, all

 

Is there any way you could help me with organizing the data from 1 column into 3 columns with their specific info below? 

As you can see in image attached, I have a Column - New Field which holds all my information.

 

I need three columns "Cognome e Nome" ||| "COD. GIUSTIFICATIVI..." ||| "VOCI MENSILI" and below each of them I would need to have the specific details "Cognome e Nome" - "Accardo Massimo", "Alessi Fabio"... then below "COD. GIUSTIFICATIVI" -"310FERIE... ", "307BANCA", "Donazione Sangue" then "VOCI MENSILI" - "4,00 ROL..", "10,00 ROL"

 

*Sometimes COD GIUSTIFICATIVI will have 1 line below it, sometimes 2, other times 3 .. meaning that I cannot come up with some rule that would always take a hardcoded number of rows below the one that I need as header.

 

It would be more like a Until find value "VOCI MENSILI" have rows above numbered x.a x.b etc. and place them under x I guess .. 

 

Would highly appreciate any help! 

 

Thanskies, 

Alex

 

 

 

Alexandra_Pops_0-1643190760442.png

 

3 REPLIES 3
atcodedog05
22 - Nova
22 - Nova

Hi @Alexandra_Pops 

 

Here is how you can do it. For added rules please provide sample input data and expected output in an excel file.

Workflow:

atcodedog05_0-1643191764550.png

 

Hope this helps : )

 

Alexandra_Pops
6 - Meteoroid

Hewwo, @atcodedog05 

 

Amazing! it works and u saved me sooo much trouble and it will be so helpful for my future workflows. so nicely done and so quick. 

Thank youuu! 

 

Have le nicest day! 

Alex

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @Alexandra_Pops 

Cheers and have a nice day!

Labels