Issue with MagicETl Filter Tile

Strongreece · 2024-05-09T04:14:30+00:00

There was an error rendering this rich post.

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".

Find more posts tagged with

Magic ETL

Accepted answers

MichelleH

@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%'

All comments

david_cunningham

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.

MichelleH

david_cunningham

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.