Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have total 15 columns in the query which am adding from 5 tables. I get an ODBC read failed error when I Try to join all 5 tables and query executes successfully when I have only 3 tables. The same query executes successfully in toad Data Point with 4 tables.
Thank you
This post contains no question, and isn't marked as such.
If you want solutions/asnwers for your problem, mark your post as a Question (the grey balloon in the discussion overview will turn dark blue). You have 15 minutes to do so
this does not answer your issue however why not just extract the data from the individual tables and then join in Qlik. I often find this faster as the complex joins probably don't use indexes.
Please check if you have duplicate name fields coming from different tables. This will cause OLEDB/ODBC failure
LOAD
CustomerName,
Country,
Phone,
Supplyer,
Phone /// This will fail!!
Thank you, I had 2 redundant columns. That was helpful!
Until Clever Anjos pointed out the problem, I was going to take this route and breakdown my queries.
Thank you.