Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Is there a size limitation of Qlik sense resident table?

I would like to do a calculation from two different tables during data load editor, so I used the resident table.

It works when I tested with some small size dummy data. However, when using the same logic to do the calculation from two resident tables with more than 100MB, there would be error.

The error says the resident table is not found.

Any suggestion is appreciated!

1 Solution

Accepted Solutions
vinieme12
Champion III
Champion III

There is no limit

The error means the table you were trying to create has not been created , probably you have tried to do resident load immediately after loading the table

Write keyword NOCONCATENATE

before the load statement of your resident table.

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

2 Replies
vinieme12
Champion III
Champion III

There is no limit

The error means the table you were trying to create has not been created , probably you have tried to do resident load immediately after loading the table

Write keyword NOCONCATENATE

before the load statement of your resident table.

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Anonymous
Not applicable
Author

Hey Vineeth, thanks so much for your help!

I nearly forget the CONCATENATE issue between two tables. This is very possible the reason. Let me check.

Thanks again!