How to map 1 value into the same row of another column in ETL
Please see attachment. I need to map a value from one column to another.
Context: Marketing's Department ID needs to be the same as its Organization ID. I've tried Value Mapper but it seems like that will only allow me to make a brand new column. I don't want a brand new column.
Please help! Which ETL function should I use?