Renaming Field Values

[nrwlafhus]

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.

[vishsaggi]

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.

[nrwlafhus]

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.

[vishsaggi]

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