Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

mgarcmun
New Contributor

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

Re: JOIN EXCEL DOCUMENT WITH TABLE OLEDB

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
New Contributor

Re: JOIN EXCEL DOCUMENT WITH TABLE OLEDB

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.

Re: JOIN EXCEL DOCUMENT WITH TABLE OLEDB

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
Community Browser