topic Re: Loading data in App Development

Loading data

Ericus — Tue, 23 Nov 2021 08:18:51 GMT

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?

Re: Loading data

brunobertels — Tue, 23 Nov 2021 11:09:00 GMT

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

Re: Loading data

Ericus — Tue, 23 Nov 2021 12:25:54 GMT

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

Re: Loading data

stevejoyce — Tue, 23 Nov 2021 13:21:03 GMT

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.

Re: Loading data

Ericus — Thu, 25 Nov 2021 10:59:16 GMT

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)