Is it possible to reference an excel list from the where clause a custom SQL statement?
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
- Labels:
- Trifacta Classic
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks Connor, I'll use that approach going forward.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Great! Feel free to reach out again if you need any more guidance. 😀
