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`;
