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

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

tulsidaskhan — Tue, 10 May 2016 14:55:36 GMT

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.

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

settu_periasamy — Wed, 11 May 2016 02:56:34 GMT

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$`;

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

tulsidaskhan — Wed, 11 May 2016 11:15:08 GMT

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

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

settu_periasamy — Wed, 11 May 2016 14:27:47 GMT

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

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

tulsidaskhan — Wed, 11 May 2016 15:29:29 GMT

Hi settu,

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

Thanks

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

settu_periasamy — Wed, 11 May 2016 15:43:13 GMT

Can you post the sample file?