How to load only 10 or 100 records from any file

[Anonymous]

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

And

how to modify the loading message in execution?

[swuehl · Accepted solution]

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.

[#3]

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;

[Anonymous]

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]

Hi,

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

[varaprasad0816]

Correct Answer

I have executed