This is probably a newbie question, but any help is appreciated. I have a workflow with 3 tables. ‘Projects’ contains project ID, and a field that identifies the name of a column to be merged. ‘Transactions’ contains transaction id, date elements (year/Month) ‘Resource’ contains a date key (year/Month) and 50 columns of resource data Currently, I am merging the Transactions table to the Resource table based on the date key which is common to both. But as a result I have 49 columns of junk resource data. I then need to manually select which columns to remove in a later step with Table Manipulator. Ideally this could be automated. What I would like to do is use the Projects table to identify precisely which column from the Resource table is needed (perhaps as a flow variable?) and use that to control which columns are merged when joining the Transactions table to the Resource table. So far I haven’t figured out the magic combinations of nodes /workflow to do this. Thanks for any help.

How select columns to merge dynamically?

mlauber71 April 7, 2023, 1:04pm 6

@RVC2023 you could create ‘dummy’ Join variables and fill them with Flow Variables. If you have varying numbers you might be able to repeat columns.