aldwinB

Discussions

MAGIC ETL Formula
Hi Guys, I am working on a workflow, I have two datasets I combined using left join. Now I have a new column "Category". Now those that are null in the category column and have have "AB" text on its Product Group name should be identified as "Above Normal" and those that doesn't have should be "Normal". But when I run it,…
Equivalent of IFERROR(VLOOKUP,IF(RIGHT(- in Magic ETL
Hi Guys, Hope all is good. I am using Magic ETL and trying to create a flow replicating the current logic of my Excel file. In Excel I have 2 datasets. On the Main sheet a column is categorizing using the formula =IFERROR(VLOOKUP(value,range,exact Match),IF(RIGHT(Category,2)="AB","Above","Below)) Now in Magic ETL data…

MAGIC ETL Formula
Hi Guys, I am working on a workflow, I have two datasets I combined using left join. Now I have a new column "Category". Now those that are null in the category column and have have "AB" text on its Product Group name should be identified as "Above Normal" and those that doesn't have should be "Normal". But when I run it,…
Equivalent of IFERROR(VLOOKUP,IF(RIGHT(- in Magic ETL
Hi Guys, Hope all is good. I am using Magic ETL and trying to create a flow replicating the current logic of my Excel file. In Excel I have 2 datasets. On the Main sheet a column is categorizing using the formula =IFERROR(VLOOKUP(value,range,exact Match),IF(RIGHT(Category,2)="AB","Above","Below)) Now in Magic ETL data…