Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
tulsidaskhan
Contributor
Contributor

how to change header row with ODBC (xlsb binary file)

Hi,

I am fetching data from xlsb (Binary file). I have created ODBC connection for this file but I am not able to fetch columns of a particular table as header are starting from 3rd row. Is there any feature as we have in Excel (Embedded labels and Header line ) to fetch proper field names. currently names are coming as F1, F2,F3 and so on.

Piyush.

5 Replies
settu_periasamy
Master III
Master III

Hi,

Try like this.. (if your headers are static in the row 3)

ODBC CONNECT32 TO [Excel Files;DBQ=FilePath\FileName.xlsb];

LOAD F1 as FieldName1,

    F2 as FieldName2,

    F3 as FieldName3,

    F4 as FieldName4

    Where RecNo()>3;

SQL SELECT *

FROM `FilePath\FileName.xlsb`.`Sheet1$`;

tulsidaskhan
Contributor
Contributor
Author

Hi settu,

Even though my headers are static (not freeze) on 3 rd row. but when I reload it using above script (without alias)  data coming but not header. could you please explain why this is happening.

Thanks,

Piyush Jain

settu_periasamy
Master III
Master III

Can you make it as ">=3" instead of ">3 ?

tulsidaskhan
Contributor
Contributor
Author

Hi settu,

I tried the same. even I have tried >2. still its picking up the data but not picking the header.

Thanks

settu_periasamy
Master III
Master III

Can you post the sample file?