Temp Table

[Pomna]

I need help figuring out what am doing wrong here. Below is my code but I keep getting the error message . Thanks

[Role Group Goals Temp]:
Concatenate
Load
if(Mapped = 'N',
[Role Name] & '|' & ApplyMap(' Nation Name to National Office',[ Nation Name],'MSS') & '|Non-SPT'
,%RoleGroupNationalOffice) as %RoleGroupNationalOffice,
ApplyMap('Numeric Role Code Sector Map',Text([Role Code Num])) as Sector,
ApplyMap('Numeric Role Code Segment Map',Text([Role Code Num])) as Segment,
if(Mapped = 'N','Non-SPT','Q' & Ceil(Num(Month(Date([Applicant Submit Date])))/3)) as Quarter,

[Role Group Mapped] as [Role Group],
ApplyMap('Nation Name to National Office',[Nation Name],'MSS') as NationalOffice,
num('0') as Goals
Resident [Applicants]
where not exists (TestMatch,[%RoleGroupNationalOffice])
//and not ([Mapped]='N')
and not isnull([Applicant ID]);

[Role Group Goals]:
NoConcatenate
Load *
RESIDENT [Role Group Goals Temp]
WHERE Quarter <> 'Non-SPT';

Drop Table [Role Group Goals Temp];

[dplr-rn · Accepted solution]

that table is getting concatenated into another one. you script has concatenate. you should change it to no concatenate

"[Role Group Goals Temp]:
Concatenate

.."

[Pomna]

Thank you. It worked!