topic Re: Skipping top 10 row and Embedded labels while Loading xlsb file format into Qlikview using ODBC in QlikView

Skipping top 10 row and Embedded labels while Loading xlsb file format into Qlikview using ODBC

venkat_dabbakut — Sat, 16 Nov 2024 18:54:29 GMT

Hi ,

I am able to load the data from xlsb files to the Qlikview using ODBC connection. Load script is generating like below

Load F1,

F2,

F3,

;

SQL Select *

From 'Filepath\FileName.xlsb'.'sheet1$';

Please suggest to skip to 10 rows and embedded labels while loading from xlsb files.Thanks in advance

Re: Skipping top 10 row and Embedded labels while Loading xlsb file format into Qlikview using ODBC

rubenmarin — Sun, 22 Mar 2020 19:19:46 GMT

Hi, maybe using a RownNo() ,field and precedent load like:

LOAD F1, F2, F3 Where Row>10 // or 11 to ignore labels ; Load F1, F2, F3, RowNo() as Row ; SQL Select * From 'Filepath\FileName.xlsb'.'sheet1$';

Re: Skipping top 10 row and Embedded labels while Loading xlsb file format into Qlikview using ODBC

Brett_Bleess — Tue, 14 Apr 2020 20:27:40 GMT

If Ruben's post got you what you needed, please be sure to close out your thread by using the Accept as Solution button on his post. This will give him credit for the help and confirm to other Members this worked.

I was thinking of trying to using the transformation wizard in the Load Script editor to do the work, but I do not know how the heck to do that on a SQL Select load, not sure if you try to load the XLSB file directly if that would work or not, that is not an extension we list, but we do use BIFF translator, so might be worth a shot to try that way to see if it might work. I would recommend Ruben's idea otherwise.

Regards,
Brett