I can't seem to figure out how to perform this mapping.
Attached is the excel document I am trying to accomplish in Qlik.
On the eWM sheet, there is a column called "testing" it is yellow. I am trying to compare it to the ECC batch's, to find errors in our system. if it returns "#N/A" it is an error. I am trying to just show these rows on a table in Qlik.
Attached is what i have so far of this.
My script is this so far..
(ooxml, embedded labels, table is ECC);
"Actual Goods Receipt Date",
num("Putaway Date (Act.)" - "Actual Goods Receipt Date") as [Lead Time eWM],
ApplyMap('MappingTable', "Batch") as "Batch Comparison",