In-DB Dynamic Join Question

[crey]

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?

[patrick_mcauliffe · Accepted solution]

@crey

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.

[crey]

@patrick_mcailiffe

Thanks for that idea, I followed it and it works for me!