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;
