Hi sivakumar,
ApplyMap is used to transfer one field from a table into another instead of joining the tables.
You first need to create the mapping table (with the field you want to transfer).
Then you can use ApplyMap to put the values in the final table.
The first load in a mapping table is always the field you are joining with and has to exist in both tables.
For example:
mapping_table:
Mapping LOAD
Value1,
Transfer_Field
FROM sourcetable1;
Then you can use ApplyMap to put this field into another table:
final_table:
Value1,
ApplyMap('mapping_table', Value1, null()) as Transfer_Field
FROM sourcetable2;
