Issue with MagicETl Filter Tile
Hello there,
I am trying to filter a dataset in MagicETL using the Filter Tile, and have confirmed that the data I wish to filter by exists in the dataset 'Cadence name' by 'Outbound - Short'. Yet everytime I try this by running a preview, I get the response "No rows matched your criteria".
Best Answer
-
@Strongreece The issue appears to be coming from the % symbols in your filter. These can serve as wildcards when using the LIKE operator, but when using the = operator it looks for exact matches. For exact matches, your filter should be
`Cadence name` = 'Outbound - Short'
. If you want to return all rows that contain that text then you want to use`Cadence name` LIKE '%Outbound - Short%'
0
Answers
-
there’s 658 out of almost 3.5 million rows that meet that criteria. Preview doesn’t process all rows, just the first 10k up to 400k. One way to test if this filter is working as expected is to attach an output dataset (“test filter”) and execute the dataflow. If the output matches, you know you are good to go.
David Cunningham
** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
** Did this solve your problem? Accept it as a solution! ✔️**0 -
@Strongreece The issue appears to be coming from the % symbols in your filter. These can serve as wildcards when using the LIKE operator, but when using the = operator it looks for exact matches. For exact matches, your filter should be
`Cadence name` = 'Outbound - Short'
. If you want to return all rows that contain that text then you want to use`Cadence name` LIKE '%Outbound - Short%'
0 -
Good catch @MichelleH! @Strongreece my comment on preview sometimes not showing rows in MagicETL when you are dealing with large datasets and a small result set still stands, but Michelle's answer should be selected as the correct solution to your post.
David Cunningham
** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
** Did this solve your problem? Accept it as a solution! ✔️**0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 602 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 695 Beast Mode
- 43 App Studio
- 39 Variables
- 658 Automate
- 170 Apps
- 441 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 386 Distribute
- 111 Domo Everywhere
- 269 Scheduled Reports
- 6 Software Integrations
- 113 Manage
- 110 Governance & Security
- 8 Domo University
- 30 Product Releases
- Community Forums
- 39 Getting Started
- 29 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive