topic Issue in loading .accdb file in QlikView

Issue in loading .accdb file

amit_saini — Fri, 13 Mar 2015 05:11:18 GMT

Hi Folks ,

I'm facing a issue , while loading this attached Amit.accdb file.

If you open this file(Say table "GSE by KT Plant Table:" , you can see fields starts from -> ID , Month , Supplier Name , Supplier Code and so on . See below:

Now I'm trying to load this sheet in QlikView through OBDC .

Select ODBC (Force 32 bit) ->MS Access database->Selecting file from the directory as below:

My problem starts here when I want to select my tables, first of all not sure why I can see too many table . Actually I'm having only two tables-> GSE by KT plant and GSE Overall in my Amit.accdb file

Second issue is if I select "GSE by KT plant" than fields below starting from "0-KM" , but if check Amit.accdb file it should starts from ID.

Looks like I can't read first 10 heading staring from "ID" until "Volume" in QLikView .

Please help me on this issue!

Thanks,

Re: Issue in loading .accdb file

Gysbert_Wassenaar — Fri, 13 Mar 2015 06:37:15 GMT

1. Disable the options Views and System Tables to hide the Querys and the system tables.

2. The fields are listed in alphabetical order. Since the order has no meaning it doesn't matter in which order you load the fields. If you want to change to order then first generate the sql and then reorder the fields.

Re: Issue in loading .accdb file

amit_saini — Fri, 13 Mar 2015 06:55:52 GMT

Thanks Gysbert for your suggestion, but if we are neglect this alphabetical order also we are missing 10 fieldsl

SQL SELECT `0-KM`,

APQP,

City,

Commodity,

`Complaints exceeding LeadTime`,

`Controlled Shipping`,

`Encoded Absolute URL`,

`Environmental registration (ISO14001)`,

GSM,

ID,

ISO9001,

`Item Type`,

`Kautex Plant`,

Logistics,

Month,

Path,

`Plant Code`,

ppm,

`Pre-serial`,

`Quality performance (58%)`,

`Quantity rejected`,

Ranking,

Rating,

Region,

Serial,

`Supplier Code`,

`Supplier Name`,

`Supplier Questionnaire`,

`Total Complaints`,

TS16949,

`URL Path`,

Volume,

Warranty,

`Work Safety`,

`Workflow Instance ID`

FROM `GSE by KT plant`;

Thanks,

Re: Issue in loading .accdb file

Gysbert_Wassenaar — Fri, 13 Mar 2015 09:53:16 GMT

If I open the ms-access file you uploaded and open the table GSE by KT plant in design mode then I see 35 fields. That is exactly the same number of fields I get when I load the table in Qlikview. If you're missing fields then these field don't exist in the ms-access file you uploaded.

Re: Issue in loading .accdb file

buzzy996 — Fri, 13 Mar 2015 11:09:56 GMT

U have to understand ur source file first!

Maybe you can try to

IMP POINT: Mightbe some other fields are available in different table in ur .accdb file,but source will show as in one view(some thing like share point lists).