Joining Tables with multiple similar field names

[#1]

How do I change the name of a field that I have a CASE WHEN statement written for? Please advise

Thanks,

Jared

[swuehl]

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?

[#3]

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]