i want map product id but it is there in 2 tables how to map ? whether its possible or not?

[#1]

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);

[MK_QSL]

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.