Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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]:
ItemCode as WasteITEMCODE;
SQL SELECT GSM,
ItemCode
FROM PUB."PM_Item"
WHERE GSM > '0';
UNQUALIFY *;
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,
SQL SELECT CostCatNum,
CostType,
DeptCode,
CostcCode,
DimA,
StepNum,
JobCode,
TxnDate,
ItemCode,
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
Hi,
are these two table linked ?
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,
SQL SELECT CostCatNum,
CostType,
DeptCode,
CostcCode,
DimA,
StepNum,
JobCode,
TxnDate,
ItemCode,
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
Brilliant thank you
Yep