Load Script - MS Access & Excel

[#1]

Hello Everyone.

I am loading data from tables in MS Access. I needed to obtain information on how to undertake following:

* Add New Column/Field for Calcuation based on existing data e.g.

**Sales = Unit Price X Quantity, Where Unit Price & Quantity are part of the Table in MS Access

I attempted to do Sales, and following is the my load script for MS Access:

ODBC CONNECT TO [MS Access Database;DBQ=C:\Users\Uday\Desktop\Qlikview Project\Files\QWT.mdb];
//-------- Start Multiple Select Statements ------

LOAD
[OrderId],
[ProductId],
[UnitPrice],
[Quantity],
[Discount],
([Unit Price*Quantity]) as [Sales];

SQL SELECT
[OrderId],
[ProductId],
[UnitPrice],
[Quantity],
[Discount],
FROM `Order Details`;
//-------- End Multiple Select Statements ------

As you can see from above, I have attempted to add a new column with following:

([Unit Price*Quantity]) as [Sales];

However, when I run the script I get the following error message:

SQL##f - SqlState: 37000, ErrorCode: 4294963792, ErrorMsg: [Microsoft][ODBC Microsoft Access Driver] The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect.

SQL SELECT

[OrderId],

[ProductId],

[UnitPrice],

[Quantity],

[Discount],

FROM `OrderDetails`

Please note the following:

* I am using Qlikview Version 11

* I searched Qlikkview community & blogs to determine a possible solution, however couldn't locate anythign very specific

I believe this should be a very a basic coding in the script that should be very easily achievable.  Your expert help, guidance is welcomed.

Thank You

Uday

[jagan · Accepted solution]

Hi Uday,

Check whether the Case of the field name differs, this may also the issue.

Regards,

Jagan.

[#3]

BIG BIG THANK YOU TO EVERYONE FOR YOUR EXCELLENT HELP THANK YOU