Restrict identifier

rickrogers — Thu, 20 Feb 2020 04:08:18 GMT

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] ;

Re: Restrict identifier

maniram23 — Thu, 20 Feb 2020 05:05:35 GMT

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] ;

topic Re: Restrict identifier in App Development

Restrict identifier

Re: Restrict identifier