topic Joining two streams of data with different number of columns on top of each other in Alteryx Designer Desktop Discussions

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

lizhaozhi — Thu, 13 Jun 2024 21:55:25 GMT

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.

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

Qiu — Wed, 12 Jan 2022 06:50:53 GMT

@lizhaozhi
Do you mean like this?

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

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

binu_acs — Wed, 12 Jan 2022 07:10:35 GMT

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

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

atcodedog05 — Wed, 12 Jan 2022 07:17:43 GMT

Hi @lizhaozhi

My take on this

Workflow:

Hope this helps : )

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

atcodedog05 — Wed, 12 Jan 2022 12:42:44 GMT

Happy to help : ) @lizhaozhi

Cheers and have a nice day!