topic Re: Rename field inside Table Box in QlikView

Rename field inside Table Box

vibhapratha — Sat, 16 Nov 2024 20:30:11 GMT

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.

Re: Rename field inside Table Box

lockematthewp — Mon, 08 Jul 2019 16:08:54 GMT

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

Re: Rename field inside Table Box

acsaggar — Mon, 08 Jul 2019 16:15:47 GMT

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.