Put 2 datasets next to eachother.

Question

Hi,

I'm looking for a simple solution to put 2 data sets next to eachother but without generating all possible combinations. Unfortunately I wasn't able to find anything in existing topics.

Here are the inputs:

KeyValue1Key112Key2543Key2765Key2987

KeyValue2Key132Key112Key1321Key2765Key2876

And expected output:

KeyValue1Value2Key11232Key1 12Key1 321Key2543765Key2765876Key2987

All help is appreciated!

AngelosPachis · Answer

Hey @The1804 ,

Based on your input, you want to join on key ID and a new field that you have to create (I named it ID) which numbers the number of records for each ID.

Then you can use a join or join multiple to bring everything together.

Hope that helps.

Angelos

example.yxmd

mceleavey · Answer

@The1804 ,

Given what I went over previously, the following workflow isolates the key value in each dataset, uses the join by record position method, and unions back together:

But this method needs the logic to be determined for it to be consistent.

M.

mceleavey_solution.yxmd

The1804 · Answer

Hi @Emil_Kos

Maybe I wasn't clear enough. I still need to join by Key value but I just need to list all values from both sources next to eachother.

Joining by record position would only work if the amount of values per key would always be the same in both sets.

I hope you understand what I mean.