How do I change the name of a field that I have a CASE WHEN statement written for? Please advise
Sorry, I don't get what you are saying. Could you post your script code? And explain what you want to get a bit more detailed?
IF you using SQL LOAD then you can use below in SQL statement
CASE WHEN Field_Name = 'Value2' THEN 'Name_XYZ'
WHEN Field_Name = 'Value2' THEN 'Name_ABC'
ELSE 'NAME 123'
END AS 'Give_New_Name'
If you can also change the field name in Load statement as below
Load 'Give_New_Name' AS [Another Name]
Retrieving data ...