community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Splitting column into 2 rows

Hi all,

 

I am trying to split a column in such a way that every other record in the column is put into a second column. For example:

  

Input.PNG

 

My output should look something like this

Output.PNG

I am not sure if I should use a Fuzzy Match or a Multi row formula for this.

 

Please help!

Thanks in advance

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hi @rajputakansha 

 

Actually a Cross-tab tool could work pretty well. Use only the Tile Tool to group by, with Unique Method.

 

clipboard_image_1.png

 

clipboard_image_0.png

 

 

Cheers,

Alteryx Certified Partner

Hi @rajputakansha I mocked up a workflow let me know what you think?

Labels