Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
trishita
Creator III
Creator III

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

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

3 Replies
YoussefBelloum
Champion
Champion

Hi,

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

trishita
Creator III
Creator III
Author

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;