Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. $300 savings extended to February 9th Learn More
vibhapratha
New Contributor II

Rename field inside Table Box

Hi, 

I created a Table box with various columns. One of the columns 'Product' has filed values = 'FXFORW' ,'FXSPOT',etc . I need to export it to excel and I need to rename all these values in 'Product' column as 'Forward','Spot' ,etc   respectively in QlikView before export. 

Labels (2)
1 Solution

Accepted Solutions
lockematthewp
Contributor II

Re: Rename field inside Table Box

When loading these values in the script, I would create another field called [Product Description]. Then you could be like:

Load [Product],

….,

if ([Product] = 'FXFORW', 'Forward',

if ([Product] = 'FXSPOT', 'Spot', …… )) as [Product Description],  

….

From ....

View solution in original post

2 Replies
lockematthewp
Contributor II

Re: Rename field inside Table Box

When loading these values in the script, I would create another field called [Product Description]. Then you could be like:

Load [Product],

….,

if ([Product] = 'FXFORW', 'Forward',

if ([Product] = 'FXSPOT', 'Spot', …… )) as [Product Description],  

….

From ....

View solution in original post

Highlighted
acsaggar
New Contributor II

Re: Rename field inside Table Box

You can use a straight table and simply add a placeholder expression like '0' or '1' and ignore that column. Straight tables should let you label your field names directly.

Alternatively you can alias each of the fields in the script but this will add unnecessary data.