How to change timezone of a column in Magic ETL based on another column
How do I change timezone of a column in Magic ETL based on the input of another column.
e.g. I have a column called Datetime, which has date-time values (e.g. 2020-12-07T00:00:00). I have another column called Timezone which has a timezone (e.g. 'UTC')
I want to convert the datetime column from America/New_York Timezone to the timezone specified in my timezone column. I use the following formula in beast mode:
CONVERT_TZ(`Datetime`, 'America/New_York', `Timezone`)
However, I get an error saying "An Unknown Error Occurred".
This formula works perfectly well in MySQL dataflow.
Can anyone help me here? Hoe to replicate this formula in a magic ETL.