Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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] ;