maya180504

[#1]

Hello!. I have a doubt. I like to do a query on a table something like

TblTemp:

Load Cantidad,CCY

Resident SPSH_NORMAL

In this table multiply the result by another field in another table. The result of the operation is summary.

Please help me with this question. Thanks in advance

[Miguel_Angel_Baeyens]

Hello,

The result should look like the following

FieldToMultiplyMap:MAPPING LOAD ID, MULTIPLIERFROM Source; TableMultiplied:LOAD ID, CANTIDAD, APPLYMAP('FieldToMultiplyMap', ID, 1) AS CANTIDAD_MULTIPLICADARESIDENT Table;

Hope this helps