Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
[Past Orders]:
LOAD
[Order Date],
[SKU ID] ,
[Order Quantity]
FROM [lib://DataFiles/Inventory Data.xlsx]
(ooxml, embedded labels, table is [Past Orders]);
Join [Past Orders]:
LOAD
[SKU ID] ,
[Current Stock Quantity],
[Units (Nos/Kg)],
[Average Lead Time (days)],
[Maximum Lead Time (days)],
[Unit Price] ,
[Unit Price]/2 as divided,
i want to multiply unit price and order quantity using mapping how to do it??
Hi, this is a join, not a mapping.
A join merges two tables in a single tble, if the 2nd table has only one row by SKU this could also work.
In this case you can de a lod using this table as source using resident
Finaltable:
LOAD *,
[Order Quantity]*[Unit Price] as Amount
Resident [Past Orders];
DROp Table [Past Orders];
The other option is using a mapping table, check the example: https://help.qlik.com/en-US/qlikview/May2022/Subsystems/Client/Content/QV_QlikView/Scripting/Mapping...
yeah it worked with mapping