Discussion Board for collaboration on QlikView Scripting.
I had a question. I have this working, but does not account for weekends and holidays in the lead time field. Do you have any suggestions? I tried making a new column in a table with this expression
networkdays (date([Putaway Date (Act.)]), date([ECC Posting Date]), $(vHolidays))
but just returns 0. Here is my script.
FROM [lib://Data files/ZB_Putaway.xlsx]
(ooxml, embedded labels, table is ECC);
"Putaway Date (Act.)" - [ECC Posting Date] as [Lead Time];
LOAD Date(ApplyMap('MappingTable', "Purchase Order" & ' ' & Product & ' ' & Batch, 'N/A')) as [ECC Posting Date],
"Party Entitled to Dispose",
"Planned Time of Goods Receipt",
"Actual Goods Receipt Date",
"Actual Time of Goods Receipt",
"Planned Time of Unloading",
"Actual Unloading Date",
"Actual Time of Unloading",
"Planned Time of Putaway",
"Putaway Date (Act.)",
"Actual Time of Putaway",
"ERP Document Item"
(ooxml, embedded labels, table is eWM);
Looks like applymap doesn't have fields in your mapping table. Can you link to one existing field from mapping table to the new table
Not sure I am grasping what you mean, but here is the table.