Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Simple Join in QlikView

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

3 Replies
Gysbert_Wassenaar
Not applicable

Re: Simple Join in QlikView

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.


talk is cheap, supply exceeds demand
oknotsen
Not applicable

Re: Simple Join in QlikView

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

May you live in interesting times!
oknotsen
Not applicable

Re: Simple Join in QlikView

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.

May you live in interesting times!