Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I'm trying to perform a query with two tables because i want to load a single table with more info.
I've theese two tables, already loaded in qlik from a db file:
Orders | Order Details |
---|---|
OrderID | OrderID |
OrderDate | ProductID |
ShipCity | Discount |
Quantity |
In script tag, I've done this:
[OrdersD]:
LOAD
[OrderID],
[OrderDate],
[ShipCity],
[ProductID],
[Discount],
[Quantity];
SQL SELECT `Orders`.`OrderID`
`Orders`.`OrderDate`,
`Orders`.`ShipCity`,
`Order Details`.`ProductID`,
`Order Details`.`Discount`,
`Order Details`.`Quantity`
FROM `Orders`
WHERE `Orders`.`OrderID` = `Order Details`.`OrderID`;
But when I perform debugger, it's only says "Connector reply error: ***"
What I've done wrong?
Thank you.
i can't understand your question: I've created a OLE DB connection with a visual foxpro db, that had that two tables.
When i load single table with qlik, it works and script generated is lke this:
[Orders]:
LOAD
[CustomerID],
[EmployeeID],
[Freight],
[OrderDate],
[OrderID],
[RequiredDate],
[ShipAddress],
[ShipCity],
SQL SELECT `CustomerID`,
`EmployeeID`,
`Freight`,
`OrderDate`,
`OrderID`,
`RequiredDate`,
`ShipAddress`,
`ShipCity`,
FROM `Orders`;
[Order Details]:
LOAD
[Discount],
[OrderID],
[ProductID],
[Quantity],
[UnitPrice] AS [Order Details.UnitPrice];
SQL SELECT `Discount`,
`OrderID`,
`ProductID`,
`Quantity`,
`UnitPrice`
FROM `Order Details`;
But if i want to load my query as a new table, doesn't work!
ok,
i fell very stupid: i notice just now that i've forgot a comma after
SQL SELECT `Orders`.`OrderID`
now it works!
sorry