Possible rerouting join

[Mirco_Kunz]

Hi

I do have the following problem:

I have a dataset, which will be prepared in the following way:

RowID	MB	MD	MN
2	|1|1|1|1|2|	|3|5|6|7|9|	|4|5|6|2|4|
..	..	..	..
..

Next Step is Split to Column for each colum:

But sometimes the dataset contains a fourth column MP, but not always.

How can I join them after Split to column, even if the MP column is missing?

Multiple Join is based on RowID

[Qiu]

@Mirco_Kunz 

How a different way, if this is what you are trying to do.

[JagdeeshN]

Hi @Mirco_Kunz ,

Please find attached an Alteryx package. This makes the number of columns dynamic, by using a batch macro.

So if there are just MB, MD and MN it will process for three. If there are MB, MD, MN and MP in the data stream, it will process for all four.

Do let me know if this helps.

Best,

Jagdeesh