I'm trying to write a macro that would join two tables using the In-DB tools but I want the columns or fields used in the join to by dynamic or updatable. Is that even possible?
Solved! Go to Solution.
Short answer - yes.
Long answer - it depends on your workflow. I would write a formula tool that looks at column and table names and generates the SQL needed for this and then pass that to a Dynamic In-DB tool.
@patrick_mcailiffe
Thanks for that idea, I followed it and it works for me!