Dynamic query

[LuisMendoza]

Hello

I need help.

I want to occupy the output of the first report in a select to a database in a second report

Does anyone know how I could do this?

The first column of the first report would occupy something like this:

Select * from table where the field in (..here would be the fields obtained from the previous report)

thanks

[Tyro_abc]

It is difficult for me to understand your requirements without a sample workflow/data diagram. If it's possible, then please explain elaborately.

[CharlieS · Accepted solution]

It sounds like you're looking for the Dynamic Input tool. You can configure a query inside that tool and also configure how you'd like it to be modified. So if you have a workflow that prepares a list of where clause arguments, then you can feed that into the Dynamic Input tool and use the "Modify SQL Query" option to update the WHERE clause in the query you set in the tool. The entire query can be modified by the Dynamic Input tool. 

https://help.alteryx.com/current/designer/dynamic-input-tool