Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to map FUELTYPE of general information with FUELTYPE of Summary table because they both contain the same field.How can I do it
Hi,
I think you're looking to connect two tables, right ?
They are already connected with a key survey id
May be try like this:
GeneralInfo:
Load
*
From GeneralInfo.txt;
ABC:
Mapping Load
FUELTYPE,
XYZ
Resident GeneralInfo;
SummaryTable:
Load
A,
B,
ApplyMap('ABC',FUELTYPE,'UnKnown') as FUELTYPE,
C,
D
From SummaryTable.txt;