Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am interested in qlikview but I have doubts.
If for a specific query I make an inner join of two tables on load. If I want then use the tables for another query without the inner join
Should I reload both tables again ?
Thank you.
Reloading the tables might not be the smartest way to tackle this but it's difficult to give a definitive answer without knowing about the logic you're trying to implement, table sizes, etc.
You could load both tables into temporary tables
Create the inner joined tables from the temporary tables
Reuse the for your second query
Drop the temporary tables
Just have the table loaded as temp table and use it where ever you need in your application.