Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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

5 Replies
Peter_Cammaert
Partner - Champion III
Partner - Champion III

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
Not applicable
Author

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

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

Not applicable
Author

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

Not applicable
Author

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

Thank you.