Load Statement to Multiply to values.

[bnelson111]

I have the following load statement which is working fine, however i wish to multiply the two values highlighted in red. Thanks in advance.

[WAsTE]:

LOAD CostCatNum,

    CostType,

DeptCode,

    CostcCode,

    DimA,

    StepNum,

JobCode as  [Production Receipt Info.JobORder1],

ItemCode as  WasteITEMCODE,

TxnDate,

ItemCode,

TxnQty;

SQL SELECT CostCatNum,

    CostType,

    DeptCode,

    CostcCode,

      DimA,

          StepNum,

    JobCode,

    TxnDate,

ItemCode,

    TxnQty

FROM PUB."PV_JobCosts"

WHERE ("TxnDate" > '01/01/2016') AND ("DeptCode" = '3-PRINT') AND ("CostType" = '1') AND ("CostcCode" = '3-PRINT') AND ("StepNum" < '1200')  ;

UNQUALIFY *;

QUALIFY GSM;

left join

[WAsTE Item]:

LOAD GSM,

  ItemCode as  WasteITEMCODE;

SQL SELECT GSM,

    ItemCode

FROM PUB."PM_Item"

WHERE GSM > '0';

UNQUALIFY *;

[YoussefBelloum]

Hi,

are these two table linked ?

[MarcoWedel · Accepted solution]

Hi,

one script solution might be:

mapGSM:

Mapping

SQL SELECT ItemCode, GSM

FROM PUB."PM_Item"

WHERE GSM > '0';

[WAsTE]:

LOAD CostCatNum,

    CostType,

DeptCode,

    CostcCode,

    DimA,

    StepNum,

JobCode as  [Production Receipt Info.JobORder1],

ItemCode as  WasteITEMCODE,

TxnDate,

ItemCode,

TxnQty,

TxnQty*ApplyMap('mapGSM',ItemCode) as GSMTimesTxnQty;

SQL SELECT CostCatNum,

    CostType,

    DeptCode,

    CostcCode,

      DimA,

          StepNum,

    JobCode,

    TxnDate,

ItemCode,

    TxnQty

FROM PUB."PV_JobCosts"

WHERE ("TxnDate" > '01/01/2016') AND ("DeptCode" = '3-PRINT') AND ("CostType" = '1') AND ("CostcCode" = '3-PRINT') AND ("StepNum" < '1200')  ;

hope this helps

regards

Marco

[bnelson111]

Brilliant thank you

[bnelson111]

Yep