Mapping field to a table

[GOKULAKANNAN]

Hi,

I have a table with 2 fields

T1:

Load 

Id,country from country.xlsx

I need to map this ID with another table which is having 2 fields 

T2: 

Load 

id1,id2

From id.xlsx

Now the id1 and id2 in T2 will have the same value as Id in T1, i need to match this id1 and id2 with Id and fetch the country matching with id1 And id2 and retrive value as country 1 and country 2.

[Or · Accepted solution]

T1:

Mapping Load Id, country from country.xlsx;

T2:

Load id1, id2, ApplyMap('T1',id1) as Country1, ApplyMap('T1',id2) as Country 2;

Should work here, if I understood you correctly