aldwinB Member

Comments

  • Thank you @MichelleH It worked, although there are some still not captured as Above normal.
    in MAGIC ETL Formula Comment by aldwinB December 2022
  • Hi @MichelleH Thanks for the correct syntax for nulls. The Excel Category field and ETL Product Group name is just the same. I just called them differently, they are just both values that I am trying to map as "Above" or "Below" My ETL formula: CASE WHEN (`Category `IS null OR `Category` = '') AND RIGHT(TRIM(`Product…
    in Equivalent of IFERROR(VLOOKUP,IF(RIGHT(- in Magic ETL Comment by aldwinB December 2022
Default Avatar