ODBC read fails in when i try to join 4 tables in Qlikview

[#1]

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

[Peter_Cammaert]

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

[Anonymous]

‌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.

[Clever_Anjos]

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!!

[#5]

Thank you, I had 2 redundant columns. That was helpful!

[#6]

Until Clever Anjos pointed out the problem, I was going to take this route and breakdown my queries.

Thank you.