Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
map1:
mapping LOAD productid,
description
FROM
M:\ONLYQLIKVIEW\DOCUMENTS\MAPPING\map.xlsx
(ooxml, embedded labels, table is product);
map2:
Mapping
LOAD productid,
discount
// promoDiscount
FROM
M:\ONLYQLIKVIEW\DOCUMENTS\MAPPING\map.xlsx
(ooxml, embedded labels, table is discount);
map3:
Mapping
LOAD customerid,
[customer name]
FROM
M:\ONLYQLIKVIEW\DOCUMENTS\MAPPING\map.xlsx
(ooxml, embedded labels, table is customer);
tomap:
LOAD orderid,
ApplyMap ('map1','map2',productid) as pid,
ApplyMap ('map3',customerid) as cid,
productid,
customerid,
gross_amount,
orderDate
FROM
(ooxml, embedded labels, table is sales);
You can check my answer or anyone's answer and you will find below options. You can select appropriate answer.
You can select only one answer as Correct and Two-Three as helpful.