mapping and applyload

[shubham21]

[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??

[rubenmarin]

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...

[shubham21]

yeah it worked with mapping