Loading data

[Ericus]

So I've had some problems when I select data from my tables, I write a select and a load for every table, but one of the tables is very large and the limiting factor is a part of another table. How do I write my load/select statements to limit data loaded to not only my customer table but also my invoice table?

[brunobertels]

hi 

may be have a look in the forum about a where exist statement to limit / select data from a table depending of value from another 

[Ericus]

Ah ok, I used the where clause, but does it have to be on the Primary Key if it is to affect loaded data on other tables as well? It seems the exist function works with Qlik and my load seizes on the invoices when I selected all because there where too many datapoints

[stevejoyce]

Exists doesnt need to be a primary key.  You can also use Keep function to limit one table based joining fields from another table.

An example is to left keep dimension tables with a fact table, so you only have dimension values where there is relevant fact data in the data set.

[Ericus]

But If I want to limit the data loaded in I have to write that distinction in my SQL query? (I receive, an error when I try to load invoiceproduct data due to the amount)