Possible rerouting join

Question

Hi

I do have the following problem:

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

RowIDMBMDMN2|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

JagdeeshN · Answer

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

sample.yxzp

Qiu · Answer

@Mirco_Kunz

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

0129-Mirco_Kunz.yxmd