Script Logic

tmumaw — Sat, 16 Nov 2024 01:26:21 GMT

Was wondering if I could have another set of eyes take a look at this logic.

CostCenterGroupHierarchy:
LOAD
NodeIDCostCenterName,
CostCenterGroupTemp AS [Profit Center],
CostCenterGroupDescriptionTemp AS [PC Desc],
if(NodeIDCostCenterName = 'RZ00000000' or
NodeIDCostCenterName = 'R120000000' or
NodeIDCostCenterName = 'R121000000' or
NodeIDCostCenterName = 'R122000000' or
NodeIDCostCenterName = 'R191000000',1,0) as NOGood
RESIDENT
[SETLEAF.CostCenterGroup]
WHERE
CostCenterGroupTemp >= [SETLEAF.From value_VALFROM] AND
CostCenterGroupTemp <= [SETLEAF.To value_VALTO] AND exists (NodeIDCostCenterName)
;

DROP TABLE [SETLEAF.CostCenterGroup];

When I check my NOGood switch here it's correct.

CostCenterGroup:
LOAD
NodeIDCostCenterName,
[Profit Center],
[PC Desc],
NOGood
RESIDENT
CostCenterGroupHierarchy
WHERE
NOGood = '0'
;
Drop Table CostCenterGroupHierarchy;

When I check it here it does not even exist in the table.....any ideas.

Thanks

//Rename Table Temp to CostCenterGroupHierarchy;
exit Script;

Re: Script Logic

tmumaw — Thu, 17 Sep 2020 17:56:06 GMT

Never mind I found it.....missing (NoConcatenate)

topic Re: Script Logic in App Development

Script Logic

Re: Script Logic