Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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
MVP
MVP

Re: Joining Tables with multiple similar field names

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

Re: Joining Tables with multiple similar field names

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]

Community Browser