Mapping field to a table

GOKULAKANNAN — Tue, 02 Nov 2021 18:53:57 GMT

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.

Re: Mapping field to a table

Or — Tue, 02 Nov 2021 19:27:35 GMT

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

topic Re: Mapping field to a table in App Development

Mapping field to a table

Re: Mapping field to a table