U have prod id and sales in one table
Table1:
prod id sales
1 100
2 200
and u have prod id and prod description in another table
table2:
prod id prod_desc
1 pen
2 paper
now what you do is, u first load the table 2
then while loading table1 u use applymap to map the prod desc from table 2 to table1,
to do this u need a key id field which is going to be prod id in the above example
in script it would be,
table2:
mapping
LOAD prodid,
desc
FROM
(ooxml, embedded labels, table is Sheet1);
table1:
LOAD prodid,
sales,
applymap('table2',prodid)as des
FROM
(ooxml, embedded labels, table is Sheet1);
PFA for more details.
by specifying as mapping while loading the second table u r telling it, that it is loaded only to be mapped by some other table.
so u don't need a drop statement for that(table2)..
moreover if u have more that one desc for the same prod then the first one will be selected the rest is ignored...
hope this helps..
-Sundar
