How to use case statements within Filter function in Magic ETL 2.0
Trying to use case statements within filter function in the ETL 2.0. '
For instance, I want to only filter out records for specific dates for only specific people. However when I use the following formula :
member = 'John Doe' then
date > '1/1/2021' ELSE NULL END
It filters out everything from the dataset. I even tried removing 'ELSE NULL' operand with no success. Any help will be appreciated