Rename field inside Table Box

[vibhapratha]

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. 

[lockematthewp · Accepted solution]

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

[acsaggar]

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.