Using In-DB tools on 2 databases

alexlyle

I know it's not possible to use IN-DB tools to join 2 databases. But, I think it might be possible to do what I am after with a macro and I'm wondering if someone could guide me with it. Database1 has 100 records coming out. Let's call the field trans_id.

I want to take those 100 trans_id's and update the where clause in my query for Database2 similar to how I might use a textbox or dropdown app tool. Does anyone have any thoughts on this? Thanks

apathetichell

I do this all of the time. I use dynamic input in-db - wherein I take the output of db 1 via datastream in - use a summarize tool and some formula tool magic - add that to a text input of a base query - use another summarize tool - and then use dynamic input in-db to create a SQL query with a dynamic large query with a WHERE clause source from another DB.

Note - I use fieldname IN(...,...) - to construct my clause.

I posted some info on this in this thread: https://community.alteryx.com/t5/Orange-County-CA/Orange-County-Alteryx-Q3-User-Group-Meeting/ec-p/973408#M13