Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI,
I am trying to load HTML file.By default in header part it is taking something else..Could anyone please try to help me out...How to ignore/remove first row...I am attaching one snapshot of loading table...
Thanks
In the File wizard, next-> enable transformation-> select first row-> delete row, that will generate something like :
Remove(Row, Pos(Top, 1) // in the script.
In the File wizard, next-> enable transformation-> select first row-> delete row, that will generate something like :
Remove(Row, Pos(Top, 1) // in the script.
While you go to the web load wizard then there are settings to remove embedded labels
Hi Hinan,
When you select table file from qlikview script. there is one option Emdedded ladels and header size. See the below screen short.
Hi
Use enable transformation step--->Conditional delete
PFA
Hope this will helps you
Thank tresesco for your quick and accurate response...
Using functions from the "Transformation Step" can work horribly when trying to load huge files.
A much more efficient solution would be:
TableName:
LOAD
*
FROM [FileName.xxx]
WHERE RecNo() > 1;
Follow the steps:
1. Select the file you want to load
2. Click enable transformation
3. select any row/column you want to remove
4. Query editor will dynamically generate the query for you