Data Model Northwind

[#1]

Hi,

I am new to QlikView and i am trying to prepare a data model using Access file.

When i am trying to put the below in Script i am getting lots of Synthetic Keys.

Can someone tell me how to go ahead with that.

ODBC CONNECT32 TO [MS Access Database;DBQ=C:\Users\DELL\Downloads\t1.accdb];

//-------- Start Multiple Select Statements ------

SQL SELECT Category,

    CategoryID

FROM Categories;

SQL SELECT Address,

    City,

    Company,

    ContactName,

    'CUST_ID'

FROM Customers;

SQL SELECT Address,

    BusinessPhone,

    City

FROM CustomersExtended;

SQL SELECT Available,

    InventoryID,

    ProductID,

    ProductName,

    SupplierID

FROM InventorySummary;

SQL SELECT CustomerID as CUST_ID,

    EmployeeID

FROM Orders;

SQL SELECT `PRODUCT_ID`,

    ProductName

FROM ProductList;

SQL SELECT Address,

    ContactName,

    CountryRegion,

    `Supplier_ID`

FROM Suppliers;

SQL SELECT Address,

    Company,

    CountryRegion,

    ID

FROM Shippers;

//-------- End Multiple Select Statements ------

Thanks

Ankit

[#2]

Thanks a lot

[its_anandrjs]

Hi,

If you got correct answer from the thread so mark it Correct/Helpful for reference

Thanks & Regards