Restrict identifier

[rickrogers]

I want to Resident Load the [Assessment] table to the [Limited Assessment] table while restricting every record in the [Limiter] table. The [Limiter] table is an excel workbook that looks like this but with many more records. Can you help?

Identifier	Inches
Measure 5	270
Measure 8	85
Measure 10	67
Measure 11	500
Measure 13	325
Measure 14	59
Measure 15	63
Measure 17	35

[Assessment] :
Identifier,
Inches
FROM [lib://Capacity/Sheet1.xlsx

[Limit Assessment] :
Identifier,
Inches
RESIDENT [Assessment] ;
DROP TABLE [Assessment] ;

[maniram23 · Accepted solution]

Use NoConcatenate before [Limit Assessnent]
Otherwise use this
[Assessment] :
Identifier,
Inches
FROM [lib://Capacity/Sheet1.xlsx



[Limit Assessment] :
Identifier,
Inches,
'' AS Flag
RESIDENT [Assessment] ;
DROP TABLE [Assessment] ;
DROP Field Flag FROM [Limit Assessment] ;