topic Re: How to remove first row while loading in QlikView

How to remove first row while loading

Anonymous — Thu, 30 Jan 2014 05:25:01 GMT

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

Re: How to remove first row while loading

tresB — Thu, 30 Jan 2014 05:29:15 GMT

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.

Re: How to remove first row while loading

sujeetsingh — Thu, 30 Jan 2014 05:30:41 GMT

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

Re: How to remove first row while loading

kumarnatarajan — Thu, 30 Jan 2014 05:30:57 GMT

Hi Hinan,

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

Re: How to remove first row while loading

Thu, 30 Jan 2014 05:38:09 GMT

Use enable transformation step--->Conditional delete

PFA

Hope this will helps you

Re: How to remove first row while loading

Anonymous — Thu, 30 Jan 2014 05:38:58 GMT

Thank tresesco for your quick and accurate response...

Re: How to remove first row while loading

Anonymous — Thu, 09 Feb 2017 14:34:33 GMT

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;

Re: How to remove first row while loading

kumarravi — Mon, 04 Apr 2022 10:04:38 GMT

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