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

Un-merge data in first two columns

Pascal_R
8 - Asteroid

Hi Alteryx Community,

 

I have a dataset where I have merged data in the first two columns.

Is there an easy way to split data so I have it on each row?

 

Best regards,

Pascal

7 REPLIES 7
atcodedog05
22 - Nova
22 - Nova

Hi @Pascal_R 

Can you provide some sample expected output It will help us get a better understanding of the usecase.

We will be happy to help : )

Pascal_R
8 - Asteroid

HI @atcodedog05 

 

See below, left the raw data I have and the right side is what I try to get with Alteryx.

 

Pascal_R_0-1644394931050.png

 

RolandSchubert
16 - Nebula
16 - Nebula

Hi @Pascal_R ,

 

I think, Multi-Row Formula tools should solve your problem:

 

2022-02-09_09-21-46.jpg

 

Each cell in the first two columns is checked, if it is empty, and if so, the value from the last cell above is used.

 

Let me know if it works for you.

 

Best,

 

Roland

atcodedog05
22 - Nova
22 - Nova

Hi @Pascal_R 

 

You would need to use multi-row formula tool to fill down the blank data for both columns like below.

 

atcodedog05_0-1644395258114.png

 

Edit: Similar as @RolandSchubert 

 

Hope this helps : )

 

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @Pascal_R 

Cheers and have a nice day!

Pascal_R
8 - Asteroid

Thank you both! I can see now the issue in my formula :)

 

Pascal_R_0-1644395387128.png

 

Qiu
20 - Arcturus
20 - Arcturus

@Pascal_R 

I think maybe we can do this a more dynamic way, in case you have more columns mreged.

And there is null cells in your material columns.

0209-Pascal_R.PNG

Labels