Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
sriharsha96
Contributor 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
MVP
MVP

Re: How to load only 10 or 100 records from any file

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.

4 Replies
MVP
MVP

Re: How to load only 10 or 100 records from any file

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.

Not applicable

Re: How to load only 10 or 100 records from any file

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
Valued Contributor

Re: How to load only 10 or 100 records from any file

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
New Contributor III

Re: How to load only 10 or 100 records from any file

Hi,

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

Community Browser