Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
May be something need to fixed when you convery XLSB into a qvd. What is the script you are using there?
I'm doing select * from XLSB file and storing the same in qvd, no transformation or logic.
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
it is like
Select *
----
'Connectionstring'.'1$'
1$ is my tab name of my xls.
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
NP
Please share your full script.
it is there in qvw..that is all...if you open the qvd file you will things are messed up.
Or can we write some where clause where it reads data from rowno 4.
Note: Where rowno>4 is not working here.