Discussion Board for collaboration on QlikView Scripting.
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.
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.
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.
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.