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

Combining rows of data that relate to one common item after parsing and unioning the data

madslawton3
6 - Meteoroid

Hello Community,

 

Please see the attached photo.

 

I have parsed some data separately from a string to get the output that I want; however, when i try to combine the two outputs, it comes up as the attached.

 

Basically, the data in row two for 'Credit/Debit' and 'currency' relates to the items in row 1 for 'date' and 'amount'. and same for the subsequent rows.

 

As such, I am looking for a way to combine rows 1 & 2, rows 3 & 4, rows 5 & 6 and so forth.

 

Is there a formula that would allow me to do this?

 

Thank you!

2 REPLIES 2
bpatel
Alteryx
Alteryx

Hi @madslawton3 ,

 

you could use the multi-row formula tool. I mocked up a workflow from what your attached picture shows. I hope this helps.

madslawton3
6 - Meteoroid

Thank you so much!!!

Labels