Passing Parameters Through Chained Apps

Xeu911

Hi everyone,

Context: I'm building a chained app to help users build SQL queries. The idea is that a user selects a schema and a table in APP_001, then in APP_002 they can choose the fields to include in the SELECT statement based on the previous selection.

APP_001:

Below is the SQL query from the Input Data tool in APP_001:

SELECT  ColumnName AS NAME,
        ColumnName AS "VALUE"
FROM    DBC.ColumnsV
WHERE   DatabaseName = '__SCHEMA__'
AND     TableName = '__TABLE__'
ORDER BY ColumnId;

I update the __TABLE__ and __SCHEMA__ values based on the user selection. From there, I extract the list of fields from the selected table, which is injected into APP_0002 using a List Box.

APP_002:

The update of the __COLS__ value works fine. Where I'm encountering an issue is in APP_002, because I don't see how I can pass the __TABLE__ and __SCHEMA__ parameters into the SQL query.

SELECT __COLS__
FROM __SCHEMA__.__TABLE__

I tried to export the query into a .yxdb file in APP_001, without success.

Does anyone have an idea how I could do this?

Thanks in advance for your help!

CR

alexnajm

Pass them into a Text Input and have that go into a Dynamic Input to replace specific strings in the query! https://help.alteryx.com/current/en/designer/tools/developer/dynamic-input-tool.html#id616097