topic Renaming Field Values in QlikView

Renaming Field Values

nrwlafhus — Wed, 06 Sep 2017 19:54:06 GMT

I have the following load script:

QVDTOCProfitCenter:

LOAD

PROFIT_CTR.PROFIT_CTR as [TOCLOC],

PROFIT_CTR.TXTMD as [TOC Location]

FROM

[$(vLoadpath2)PROFIT_CTR.qvd]

(qvd)

Where exists ([TOCLOC], [PROFIT_CTR.PROFIT_CTR])

and PROFIT_CTR.CO_AREA = 'HOL'

and PROFIT_CTR.LANGU = 'E'

and PROFIT_CTR.DATETO > Today() and

PROFIT_CTR.DATEFROM <= Today();

This load gives me identical names for different PC ID's. How can I override these field names? In other words, for ID# 5555 I want to name it 'Field Value 1' and for 5556 I want 'Field Value 2', instead of 5555 and 5556 both named the same.

Re: Renaming Field Values

vishsaggi — Wed, 06 Sep 2017 21:25:07 GMT

Is your Field ID# a fieldname which has values like 5555, 5556? How many values you have to change? You can use a pick(Match()) or a Mapping table. Give us some more info to help you.

Re: Renaming Field Values

nrwlafhus — Thu, 07 Sep 2017 14:52:33 GMT

Yes, [TOCLOC] is the field ID# which has values like 5555, 5556. I have two [TOCLOC] ID #s that have the same [TOC Location] name. It is the [TOC Location] name that I want to modify.

Re: Renaming Field Values

vishsaggi — Thu, 07 Sep 2017 14:56:48 GMT

I am confused, would you mind posting some sample data with your expected output so that we can figure it out?