Magic ETL - Add a "Flag" column based on comparing a date in one column to current date
In my data I have a date column. I'd like to create a column via Magic ETL (want to use in a filter) that looks at the date a determines if it is in the past or in the future. Here is a short video that explains.
From an Excel formula standpoint, it would be: =IF([@[Last Update]]>TODAY(),"Future","Past")
I tried with value mapper, but no luck.