Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sriharsha96
Creator II
Creator II

How to load only 10 or 100 records from any file

How to load only 10 or 100 records from any file?

And

how to modify the loading message in execution?

1 Solution

Accepted Solutions
swuehl
MVP
MVP

You can use something like

First 10 Load * from abc.csv;

to load the first 10 records. Or use the debug dialog (open from script editor) and limit the numbers of records to load in any LOAD.

View solution in original post

5 Replies
swuehl
MVP
MVP

You can use something like

First 10 Load * from abc.csv;

to load the first 10 records. Or use the debug dialog (open from script editor) and limit the numbers of records to load in any LOAD.

View solution in original post

Not applicable

You could also use   TempTable: Load *, rowno() as Row_Number Resident Tablename;  Final Table:  Load *, 'Temp' as TempFiled Resident TempTable where Row_Number>= 1 and  Row_Number <= 100;  Drop Table TempTable; Drop Table Tablename;

srikanthsri1
Specialist
Specialist

you can also do like this ............

in script editor window  go to -select debug  and in that select limit load enter the no. of records like 10 or 100 and hit run ..

hope this helps

vinod22kv
Creator
Creator

Hi,

I want to leave first 10 Rows how to do that please

varaprasad0816
Creator II
Creator II

Correct Answer

I have executed