Skip to main content
Announcements
New: No-code data prep in Qlik Cloud Analytics™ TAKE A TOUR
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to remove first row while loading

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

1 Solution

Accepted Solutions
tresesco
MVP
MVP

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.

View solution in original post

7 Replies
tresesco
MVP
MVP

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.

sujeetsingh
Master III
Master III

While you go to the web load wizard then there are settings to remove embedded labels

kumarnatarajan
Partner - Specialist
Partner - Specialist

Hi Hinan,

When you select table file from qlikview script. there is one option Emdedded ladels and header size. See the below screen short.

Not applicable
Author

Hi

Use enable transformation step--->Conditional delete

PFA

Hope this will helps you

Untitled.pngUntitled1.png

Anonymous
Not applicable
Author

Thank tresesco for your  quick and accurate response...

Anonymous
Not applicable
Author

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;

kumarravi
Contributor III
Contributor III

Follow the steps:

1. Select the file you want to load

2. Click enable transformation

kumarravi_0-1649066580341.png

 

kumarravi_1-1649066642536.png

 

3. select any row/column you want to remove

 

4. Query editor will dynamically generate the query for you

Happy Learning 🙂 !