Applymap in qlikview

[Korto2024]

Hi ,

i have this script 

Product:

load 

id,

descreption

from source;

sales:

load 

idproduct,

amount

from source ;

I want this result

id_product,descreption,amount 

how can i do it by applymap

thanks

[MatheusC · Accepted solution]

Hi, @Korto2024 

The id being the value corresponding to the two Product and Sales tables,

try like the example below:

Products:
mapping
load
Id,
description
from the source;

 

sales:
load
idproduct,
ApplyMap('Product',idproduct) as per description,
amount
from the source;

https://help.qlik.com/pt-BR/qlikview/May2023/Subsystems/Client/Content/QV_QlikView/Scripting/Mapping...

Regarts,
Matheus