Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
mgarcmun
Contributor II
Contributor II

JOIN EXCEL DOCUMENT WITH TABLE OLEDB

Hi everyone,

I've a doubt with QlikSense Script.

If could be possible to join an excel document with one table from my database (OLEDB) without load the last one?

My table contains a lot of data and i need to join the information fastly.

I've researched the KEEP function (INNER KEEP) but I don't know certainly if is the best solution.

Kind Regards.

Teresa.

3 Replies
Gysbert_Wassenaar

I'm not sure I understand. I'll tell you what's not possible.

It is not possible to join two tables without loading both tables.

It's not possible to load one table and use the Keep function on a table you do not load.

Can you try to explain in more detail what you want to achieve? Try to avoid explaining in solutions. Just explain the result you're after.


talk is cheap, supply exceeds demand
mgarcmun
Contributor II
Contributor II
Author

Hi,

I just want to see my excel data and some rows of my db table.

I need load the information from my db table but it has a lot of rows.

The result is a table with join information from the excel doc and the db table.

Thank you so much.

Gysbert_Wassenaar

and some rows of my db table.

Do you know which rows? If you do you can create a WHERE clause for your SQL SELECT statement so you only retrieve those records.


talk is cheap, supply exceeds demand