ApplyMap

[My_Rebecca]

My  first time to use applymap, not succeed. How to correct it?

The mapping link is "Material Document" in sheet1 and "GR Number" in sheet PTO. I need to copy the Truck arrival to sheet1, thanks.

Map1:
Load
"GR Number",
"Truck arrival"
FROM [lib://FLD_DI_LOG_Reporting/Control Tower DC Report/DC TJ/GR/3PL/inbound report_*.xlsx]
(ooxml, embedded labels, table is PTO);

LOAD "Material Document" as "GR Number",
Plant,
"Storage Location",
"Movement Type",
"Material Document",
"Material Doc.Item",
"Posting Date",
"Time of Entry",
"Special Stock",
Supplier,
Material,
"Material Description",
Quantity,
"Unit of Entry",
"Amount in LC",
"Purchase Order",
Item,
"Sales Order",
"Sales order item",
ApplyMap(Map1,"Material Document", null()) as "Truck arrival" from Map1
FROM [lib://FLD_DI_LOG_Reporting/Control Tower DC Report/DC TJ/GR/SAP/DC TJ GR_2*.XLSX]
(ooxml, embedded labels, table is Sheet1);

[sidhiq91]

@My_Rebecca  Please refer to the below link on using ApplyMap function.

https://community.qlik.com/t5/QlikView-App-Dev/quick-applymap-example/td-p/515616 

Also, I see you are missing the keyword 'Mapping' before load key word in the table Map1

If this resolves your issue, please like and accept it as a solution.

[My_Rebecca]

dear，

Error remains the same. How to correct it?

Map1:
Mapping Load
"GR Number",
"Truck arrival"
FROM [lib://FLD_DI_LOG_Reporting/Control Tower DC Report/DC TJ/GR/3PL/inbound report_*.xlsx]
(ooxml, embedded labels, table is PTO);

LOAD "Material Document" as "GR Number",
Plant,
"Storage Location",
"Movement Type",
"Material Document",
"Material Doc.Item",
"Posting Date",
"Time of Entry",
"Special Stock",
Supplier,
Material,
"Material Description",
Quantity,
"Unit of Entry",
"Amount in LC",
"Purchase Order",
Item,
"Sales Order",
"Sales order item",
ApplyMap(Map1,"Material Document", null()) as "Truck arrival"
FROM [lib://FLD_DI_LOG_Reporting/Control Tower DC Report/DC TJ/GR/SAP/DC TJ GR_2*.XLSX]
(ooxml, embedded labels, table is Sheet1);

[p_verkooijen · Accepted solution]

Single qoute the mapping name in the Applymap

ApplyMap('Map1',"Material Document", null()) as "Truck arrival"

[My_Rebecca]

Many thanks, it does help me a lot.

Have a nice day!