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.
//Rename Table Temp to CostCenterGroupHierarchy; exit Script;