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
.png "Luminary Alumni"){kind=icon}