Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Joining Tables with multiple similar field names

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

Thanks,

Jared

2 Replies
swuehl
MVP
MVP

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?

Not applicable
Author

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]