Column names are coming like @1 @2 @3

[mishraamit2485]

Hi All,

I was trying to load data from XLSB fle format, for that I had created ODBC connection as conventional file wizard wont work here.

First i created the qvds(select * from XLSB file no transformation)  and then loaded the data in qvw, while reading the data from qvw i deleted some header columns from the qvd like below.

Remove(Col, Pos(Top, 1))

Remove(Col, Pos(Top, 2))

My problem is now all the column names are coming like @1 @2 @3 after loading.

Format of my XLSB is like.

Header 1	Header 2	Header 3	Header 4
Crap Header
Crap Header
Account Number	Date	State	City

attached the sample app and qvd(note we must create the odbbc connection to read the xls)

[sunny_talwar]

May be something need to fixed when you convery XLSB into a qvd. What is the script you are using there?

[mishraamit2485]

I'm doing select * from XLSB file and storing the same in qvd, no transformation or logic.

[sunny_talwar]

Does the script include something like this?

(ooxml, embedded labels, table is Sheet1);

or

(ooxml, no labels, table is Sheet1);

Make sure it says embedded labels.

Disclosure: I have never loaded from XLSB, so not really sure how it works

[mishraamit2485]

it is like

Select *

----

'Connectionstring'.'1$'

1$ is my tab name of my xls.

[sunny_talwar]

I guess I don't really know how it can be done. May be someone who has worked with it can offer better help.

Apologize for not being able to help

[mishraamit2485]

NP

[tamilarasu]

Please share your full script.

[mishraamit2485]

it is there in qvw..that is all...if you open the qvd file you will things are messed up.

[mishraamit2485]

Or can we write some where clause where it reads data from rowno 4.

Note: Where rowno>4 is not working here.