Dynamic Join tool

Hi there -

I have 2 data sets whereby the the columns in the data sets are selected at run time using a list box tool.

I want to then join these two data sets after the user has selected the columns. the columns in each data set will have the same name,

Is there a way to have the join tool join on the columns that the user has selected, rather than needing to predefine the matching criteria?

Thanks!

Capture.PNG

Dynamic Processing

Join

Accepted answers

FinnCharlton

Hi @kaneb3 , you can look into changing the XML of the Join tool using the action tool with the 'Update Raw XML with formula' option. However I've gone about it a different way using Dynamic Rename tools:

Screenshot 2023-08-21 171624.png

The user uses the Drop Down to choose the field they want to join on
This chosen field is dynamically renamed to [Join] before the Join tool, which Joins the two tables on the chosen field.
The chosen field is then dynamically renamed back to it's original name

Hope this helps!

Choose Join field.yxwz

All comments

FinnCharlton

Screenshot 2023-08-21 171624.png

The user uses the Drop Down to choose the field they want to join on
This chosen field is dynamically renamed to [Join] before the Join tool, which Joins the two tables on the chosen field.
The chosen field is then dynamically renamed back to it's original name

Hope this helps!

Choose Join field.yxwz

Prometheus

You can add a Drop Down interface tool for each side of the join. It's not dynamic because if you want to join on more than one field, you'd have to add another Drop Down tool for each side of the join.

Select Fields for Join.PNG

Choose Join Field.yxwz

kaneb3

thanks for your help guys

achinnve

Hi Finn can you please share workflow which you tried to make dynamic join.

Thanks

Ramirezphl

Hi @FinnCharlton is there also a way to use List box to update the list of field from Left Join and Right Join using XML?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703