I have table A, where I have 164 distinct values for column CODE as follows:
I also have a CSV file where all of these codes above are mapped to a different values that our software understands:
May-Update-DTO --> None Shift
Terminated --> Value Time
Breaking --> None Dom
One-Two-One --> POE Exec
"None" --> Manual
I have to essentially source this CSV file and update table A per the CSV values above. I can potentially load these CSV files into a local table. What would be the best way to accomplish this? CSV file has like 250 records.
Thank you for any ideas!