Can a list created in another recipe be used as a filter in the creation of another dataset using SQL?

[ChristianB1]

Original dataset steps are done to create a list of accounts, these accounts then need to be used as a filter to create another dataset using SQL. This dataset will then be joined back to the original dataset.

[APrasad_Tri]

Hi @Christian Bankett? , thank you for reaching out.

If you are creating output and extracting the data in any table, then you can create custom SQL to join with the respective table and create your dataset.

Suppose you save the output of the list of accounts in table Acc. Now you can use this table Acc and join it with another table df (dataset) using custom SQL.

Add another recipe to Original recipe 1 and join the df recipe and get your final output.

Hope this helps.

Best,

Apeksha