Join Multiple Tool - Combine fields in common into one column

[masakazuenami]

I need to combine all the fields in common used in Join Multiple so that it will look like the one indicated as the Desired Result below.  What is the best way to go about this?  I would appreciate your help!

[jasperlch · Accepted solution]

Hi @masakazuenami 

Since I do not know if you will have "Input Entity" columns than that shown in your sample dataset. I have created a more dynamic approach which will accept any number of "Input Entity" columns. 

So, basically what the workflow does is:

1. Select on the fields with name ending with "Entity"

2. Transpose the columns

3. Filter out all the Nulls

4. Group by each record and Entity value

5.. Join the data back to the original dataset

Hope this helps. 

Jasper

[grazitti_sapna · Accepted solution]

Hi @masakazuenami , try this if it works for you.

Thanks.

[masakazuenami]

Hi @jasperlch

This works perfectly.  I like how it works dynamically.  Thank you!

[masakazuenami]

Hi @grazitti_sapna 

This works perfectly.  I was not aware and have never used Dynamic Select Tool before.  Looks very useful.  Thank you!  

[grazitti_sapna]

Hi @masakazuenami , you are welcome, I am glad this worked for you.

Thanks.