Is it possible to reference an excel list from the where clause a custom SQL statement?

[454194e5f165950379e6]

If you have a list of accounts or id numbers saved in an excel file, is it possible to reference that from a custom sql statement in trifacta? This would replace typing out all of the criteria in a where statement within a custom SQL query.

[Trifacta_Alumni]

Hi @Samuel Kazman?,

If you want to use data contained in an Excel file to filter a relational database source, we recommend doing this directly in the transformer grid instead of through a custom SQL dataset. To create the filter, you should import your Excel file as a new dataset, add that dataset to your flow, and then create an inner join with your relational database source. By performing the inner join, Trifacta will only retain rows where the accounts or ID numbers are present in both the Excel file and the database table.

I hope this helps! If it does, please mark this answer as "Best" so that other users know your question has been answered.

[454194e5f165950379e6 · Accepted solution]

Thanks Connor, I'll use that approach going forward.

[Trifacta_Alumni]

Great! Feel free to reach out again if you need any more guidance. 😀