How to do mapping load of two common datafield between 2 different table

[trishita]

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

[YoussefBelloum]

Hi,

I think you're looking to connect two tables, right ?

[trishita]

They are already connected with a key survey id

[balabhaskarqlik]

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;