Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
If only in the first row one of the other columns is empty, you can check against this column:
...
where Len(Trim("Column2"));
Or check against the record number
where RecNo() >1;
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