Filter data during Load

[#1]

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

[Clever_Anjos]

I think that your query is taking too much time to run.

Maybe you should get your values from Excel and pass them as a parameter on Where clause of your SQL query.

[#3]

james, I solved my issue using this

LOAD

    field1,

    field2

FROM Excel_Small;

left join

LOAD

    field1,

    field3

FROM Excel_Large;

I hope it helps you