This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
How to load only 10 or 100 records from any file?
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.
View solution in original post
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
I want to leave first 10 Rows how to do that please
I have executed