Hello everyone,
I have created a batch macro and would like to figure out how to dynamically update the join. Furthermore, each row in my control parameter vector has a list of the different columns I would like to base my join on ex: Record 1=(x,y,z) and I would like to join on columns x, y, and z. Let me know if this makes sense and or if it is possible!
Thanks,
Nick
Solved! Go to Solution.
Hi @nickgomez610, would you be able to share your workflow for us to look at? It'll help us better understand your setup and help figure out a solution.
An easy way to do this often is to transpose the fields and then join on name and value as then the field names will be data in the Name column.