Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to load only 10 or 100 records from any file?
And
how to modify the loading message in execution?
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.
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.
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;
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
Hi,
I want to leave first 10 Rows how to do that please
Correct Answer
I have executed