Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Restrict identifier

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

1 Reply
Highlighted
Creator II
Creator II

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