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

[bhavvibudagam]

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

[swuehl]

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

...

where Len(Trim("Column2"));

[swuehl · Accepted solution]

Or check against the record number

where RecNo() >1;

[effinty2112]

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