Magic ETL Help - Overwrite value in a column if another column equals one of two values
In our sales system there was a recent change to a part number, and I need to correct history in the dataset. If the 2nd Item Number is either "LOT SQD STOCK" or "LOT SQD SPECIAL" then I want to overwrite the value in the Supplier ID column to be "SQD" otherwise I want the Supplier ID column keep it's current value.
I'd like to do this in Magic ETL if I can.
Here's the basic logic:
IF 2nd Item Number equals with "LOT SQD STOCK" OR "LOT SQD SPECIAL"
THEN Supplier ID equals "SQD"
ELSE Supplier ID