topic Re: mapping and applyload in Data Movement & Streaming

mapping and applyload

shubham21 — Wed, 19 Mar 2025 23:06:21 GMT

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

Re: mapping and applyload

rubenmarin — Wed, 02 Nov 2022 11:04:30 GMT

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/MappingFunctions/ApplyMap.htm

Re: mapping and applyload

shubham21 — Thu, 03 Nov 2022 07:30:11 GMT

yeah it worked with mapping