This content has been marked as final. Show 11 replies
I am loading a small (50K) excel sheet and a large (2M) oracle table, I would like to only load the data in the oracle table that is common to both datasets thus reducing the load time. I know I could do this outside of Qlikview, just wondered if I was missing some option/script tip to do this?
Also, is a 2million row, 100 column considered big for qlikview to manage? Uusually I am looking at a good 3-4 hours to load this - any tips to improve performance or only load changes to the table not a full refresh each time?
Thanks in advance