Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Nikhil2725
Creator II
Creator II

Data Load

Hi,

I have a Straight table which includes dimensions and measures.

It has around 350 dimensions and measures with 2500+ rows.

I want to limit it for 500 rows only for the load to layout with possibility to extract ALL the data (2500+ rows) to excel file.

How do I do it?

Thanks.

3 Replies
Channa
Specialist III
Specialist III

try use rownum()

 

 

Channa
Nikhil2725
Creator II
Creator II
Author

Hi Channa,
Can u please explain in brief...
If I use Rownum() can i restrict the data to load only 500 rows and while exporting the data can I able to export all the 2500+ rows in the excel file?
jonathandienst
Partner - Champion III
Partner - Champion III

>>I want to limit it for 500 rows only for the load

If you limit the load, then you will only be able to export what you loaded. A full export will require a full set of data. You can use dimension limits to display only the first 500. 

But it depends on what should be exported. If the export can be a CSV file, and all the data (dimensions and measures) are in single file, then you can export during the load using STORE. After the store  statement ,  you could do a reload of the resident table with a filter or a FIRST prefix to return only 500 rows and drop the full table.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein