topic Re: Loading .accdb header lines issue in QlikView

Loading .accdb header lines issue

saumyashah90 — Fri, 09 Aug 2013 07:25:12 GMT

Hi All,

I connected with OLEDB connection and also loaded contents but i faced one problem is

Header 1	Header 2	Header 3

Date	First Name	Last Name
231213	abc	ghi
123123	def	jkl

In here I have header1 ,2,3 as my forst row as a header row and same thing remains when i load it in qlikview.

I also tried loading it into qvd and then loaded it again but same problem(i could do the transformations but was not able to make required line as header row)

I could didnt get header line option as we get in normal excel load.

Please guide me in gettin Date,First Name and Last Name as my header row .

Re: Loading .accdb header lines issue

marcus_sommer — Fri, 09 Aug 2013 11:32:27 GMT

Header1 as Date (and so on) with a preceding load - don't worked?

- Marcus

Re: Loading .accdb header lines issue

saumyashah90 — Fri, 09 Aug 2013 11:55:52 GMT

Hey Marcus,

This is wont be possible for me, i have 100's of fields and not only one sheet...i have many sheets with that number of fields.I need not make any changes in data or format.

Re: Loading .accdb header lines issue

anandathome — Fri, 09 Aug 2013 11:57:07 GMT

Can you check you have similar settings as attached?

Re: Loading .accdb header lines issue

saumyashah90 — Fri, 09 Aug 2013 12:03:32 GMT

Yes its a same setting.

Like you have field names getting loaded, I have F1,F2,F3 and so on because i have main field names in 3rd or 4th row.

Re: Loading .accdb header lines issue

marcus_sommer — Fri, 09 Aug 2013 12:05:23 GMT

You could build from the first and second row a mapping table (perhaps per cross table or in a loop) and use this table for a rename-statement.

rename table (using mapname | altername to neuername { , altername to neuername } )

- Marcus

Re: Loading .accdb header lines issue

ravishankarqv — Fri, 09 Aug 2013 12:12:40 GMT

Hi Saumya,

Are you sure that you have date in MS Acccess (accdb) properly defined? If you can see data in MS Access as in attached, you should not have any problem in Qlikview Loading.

First One is Table View and second on is Design View on MS ACCESS

HTH

Ravi