Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.
I am confused, would you mind posting some sample data with your expected output so that we can figure it out?