Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi QV users,
i've a problem with applymap.
i've three table, called table1, table2 and table3.
The key field between table1 and table2 is called key1, while the key field between table2 and table3 is called key2.
No one field link table1 and table3.
So, i need to link a field in table3 with table1.
How can i do it?
Thanks,
Mattia
I guess you could use double applymap.
MapA:
Mapping load Key1, Key2
From Table2;
MapB:
Mapping load Key2, YourField
From Table3;
Load *,
Applymap('MapB',Applymap('MapA', Key1)) as YourField
From Table1;
I guess you could use double applymap.
MapA:
Mapping load Key1, Key2
From Table2;
MapB:
Mapping load Key2, YourField
From Table3;
Load *,
Applymap('MapB',Applymap('MapA', Key1)) as YourField
From Table1;
Thank you so much, Vegar!
Your solution is perfect!!!
Mattia