Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
satyam285889
Contributor II
Contributor II

SQL Table Left Join to OLE DB Table

This is the error I'm getting after trying to Load Data.

ERROR:

Started loading data
 
Connecting to Northwwind - SQL
Connected Shipper_Map << Shippers Lines fetched: 3 Products_Map << Products Lines fetched: 77 Orders << Orders Lines fetched: 830 OrderDetails << OrderDetails Lines fetched: 2,155
 
The following error occurred:
Connector reply error: ErrorSource: Microsoft SQL Server Native Client 11.0, ErrorMsg: Incorrect syntax near '`'.
 
The error occurred here:
SQL SELECT Discount, ExtendedPrice, OrderID, ProductID, Quantity, UnitPrice FROM `Order Details Extended`
 
Data has not been loaded. Please correct the error and try loading again.
 
 
My Query:

Left Join(OrderDetails)
LOAD
Discount,
ExtendedPrice,
OrderID,
ProductID,
Quantity,
UnitPrice;
SQL SELECT Discount,
ExtendedPrice,
OrderID,
ProductID,
Quantity,
UnitPrice
FROM `Order Details Extended`;
 
Labels (1)
0 Replies