community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
SOLVED

In-DB Dynamic Join Question

Highlighted
Atom

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?

@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.

Atom

@patrick_mcailiffe

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

Labels