Automatically update the column value by current month and year in Magic ETL
I got a table on below and some columns using month/year as column name.
i would like to make an automatically Magic ETL and set a logic condition like below:
if the date(column name) < current month and year (let say 08/2022)
then all value would be clear as 0 value under the column (01/2022, 02/2022, 03/2022......07/2022) and the value under 08/2022, 09/2022....12/2022 would not changed.
the goal is i dun want to change the data structure.
could someone give me some advice on it?