topic Re: How to Remove first row from Excel source with <> dynamically in QlikView

How to Remove first row from Excel source with <> dynamically

bhavvibudagam — Wed, 25 Nov 2020 16:16:04 GMT

Hi Every one,

In my source Excel Files

First Row contains the Total count of cells in column1 i.e., 88. I need to remove this first row in data model.

I have tried like this

FROM [lib://Folder/Source.xls]

(biff, embedded labels, table is Sheet1$) where "Column1" <> '88';

It's working but its a static method. Is their any way to remove first row from excel dynamically from Column1

Thanks in advance

Re: How to Remove first row from Excel source with <> dynamically

swuehl — Sat, 09 Sep 2017 10:29:09 GMT

If only in the first row one of the other columns is empty, you can check against this column:

...

where Len(Trim("Column2"));

Re: How to Remove first row from Excel source with <> dynamically

swuehl — Sat, 09 Sep 2017 10:30:10 GMT

Or check against the record number

where RecNo() >1;

Re: How to Remove first row from Excel source with <> dynamically

effinty2112 — Sat, 09 Sep 2017 10:54:04 GMT

Hi Bhavani,

If you're importing using the File Wizard set the Header Size to Lines and the value to 2. this will take out the column names and you'll need to add these back in in the script.

Regards

Andrew