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

Joining two streams of data with different number of columns on top of each other

45179902
8 - Asteroid

I imported some data from a text file. This file includes many rows of data like this:

 

B121223123  ABC Company Limited

IPS 2312323 12323 12323 123232 123232

B312323223  DEF Company Limited

IPS 1232132 12323 12323 123232 123232

B123932971  GHI Company Limited

IPS 1232323 12323 12323 123232 123232

 

Since the rows have different number of columns with the company on the first row spanning across multiple columns, I got to use a filter tool to get the IPS rows out and perform my tasks. Now I want to join them back with the company name rows which are currently at the false anchor of the filter tool.

 

How do I stack the rows back together? I've used Record ID to label the lines, but I'm not sure how to get the lines back together like they're in the text file. I believe the company name row's IDs are ID of IPS rows + 1 or something similar.

4 REPLIES 4
Qiu
20 - Arcturus
20 - Arcturus

@45179902 
Do you mean like this?

Better take a look at the latest weekly challenge, a lot of parsing... 😁

Capture3A.PNG

binuacs
20 - Arcturus

@45179902 based on my understanding you need to use a union tool to stack them back

 

binuacs_0-1641971393705.png

 

atcodedog05
22 - Nova
22 - Nova

Hi @45179902 

 

My take on this

 

Workflow:

atcodedog05_0-1641971853561.png

 

Hope this helps : )

 

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @45179902 

Cheers and have a nice day!

Labels