Magic ETL - filter with not in
Please forgive me if this is a stupid question but until this point all of my dataflows have been in mySQL or Redshift and I am trying to utilize the Magic ETL where possible looking for performance gains. Common scenario is to get a list of accounts and use that in a where clause to exclude those records from a result.
Example - select * from data where account not in(select account from exclusion_accounts)
This needs to be a dynamic list because the values are always changing so I cannot create a filter by with each value.
Can this be accomplished in Magic ETL?
- 10.7K All Categories
- 13 Getting Started in the Community
- 41 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.5K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 303 Use Cases & Best Practices
- 503 APIs
- 120 Apps
- 48 News
- 753 Onboarding
- 1.2K 日本支部
- Private Company Board