topic Simple Join in QlikView in QlikView

Simple Join in QlikView

Thu, 11 Jun 2015 20:38:37 GMT

Hi,

I am trying to import data from 2 tables with a simple SQL join such as:

SQL SELECT top 100* FROM TABLE_1 a

inner JOIN

TABLE_2 b on a.column_name=b.column_name;

But I am getting an error saying OLEDB read failed. Please guide on how I should correct it to get the query ready to load the data into QV

Kindly help.

Thanks

Re: Simple Join in QlikView

Gysbert_Wassenaar — Fri, 12 Jun 2015 05:11:46 GMT

The sql statement is send directly to the database. If you get an error then either the database can't process the sql statement or there's another problem with the OLEDB driver and/or the database. Try the same sql statement in another database tool.

And make sure there's a space between 100 and the *. 100* is not a valid number.

Re: Simple Join in QlikView

oknotsen — Fri, 12 Jun 2015 12:19:26 GMT

Alternatively, load the data into QlikView and do the join there.

Re: Simple Join in QlikView

oknotsen — Fri, 26 Jun 2015 11:44:13 GMT

If your question is answered, please flag the right answer and close the topic.

If not, please make clear how we can help you more.