Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
imrasyed
Partner - Creator II
Partner - Creator II

Loading Headers from third Row

Hi Experts,

I have .xlsb file as a source but the Headers start from 3 row.Upon doing Sql select I am getting Fields as 

F1,F2.....F28.

Can we instead load the excel from the third row as the Headers start s from 3rd row?

Below is my Sql script generated.

SQL SELECT `Quarterly light vehicle engine production 2013-2025`,
F2,
F3,
F4,
F5,
F6,
F7,
F8,
F9,
F10,
F11,
F12,
F13,
F14,
F15,
F16,
F17,
F18,
F19,
F20,
F21,
F22,
F23,
F24,
F25,
F26,
F27,
F28,
F29,
F30,
F31,
F32,
F33,
F34,
F35,
F36,
F37,
F38,
F39,
F40,
F41,
F42,
F43,
F44,
F45,
F46,
F47,
F48,
F49,
F50,
F51,
F52,
F53,
F54,
F55,
F56,
F57,
F58,
F59,
F60,
F61,
F62,
F63,
F64,
F65,
F66,
F67,
F68,
F69,
F70,
F71,
F72,
F73,
F74,
F75,
F76,
F77,
F78
FROM `C:\Qlik\Source\test.xlsb`.`Data$`;

 

Highly appreciate your help

6 Replies
Shubham_Deshmukh
Specialist
Specialist

hi @imrasyed ,

Ya, its possible. Just increase header size during load, it will load data from desired row,

 

wewe.PNG

Abhi_WP
Contributor III
Contributor III

Learned something new today. Thanks 🙂

Shubham_Deshmukh
Specialist
Specialist

Thats what we do on Community Abhi, Learning !!!!!!!
Happy Qliking !!
imrasyed
Partner - Creator II
Partner - Creator II
Author

Thanks Subham,
But the source is .xlsb file and had to load it using ODBC connection.
So I am not able to see the Header Size option in wizard.
Its not a regular excel load instead its a SQL Select where we dont have that option.
Any alternative please let me know!!
ImRakeshBanik
Contributor
Contributor

Exactly I cant find a way to limit Header size of an XLSB file from sharepoint.

Can anyone help me in this too?

marcus_sommer

I doubt that there are possibilities to configurate and/or customize the database and/or the driver to pick the n row as the table-header. But you could load this row and then looping over all values or crosstable the values to create a mapping to rename the fields later or applying any similar logic.

Beside this you could of course create the load-statement manually with an appropriate renaming, like:

...
F1 as FieldX,
F2 as FieldY
...

- Marcus