topic Re: Load data from Two or more Tables simultaneously in QlikView

Load data from Two or more Tables simultaneously

Anonymous — Mon, 12 Dec 2016 11:56:56 GMT

Hi, the idea behind my question is so simple, and I think that the solution will be so. I have two tables loaded from excels with different data and, to create a 3rd one I need to access on both simultaneously :

Table 1: [Product Serial Number]

[Failure Date]

Table 2: [Product Serial Number]

[Product Installation Date]

My aim is to create a 3rd table with the amount of time between [Failure Date] - [Installation Date] as a variable.

Nowadays my solution is to left joint table 1 and table 2 but what I want is to have It in separate if it is possible.

Re: Load data from Two or more Tables simultaneously

Gysbert_Wassenaar — Mon, 12 Dec 2016 12:00:29 GMT

If you want you can use a mapping table and the applymap function. See this blog post: Don't join - use Applymap instead

Re: Load data from Two or more Tables simultaneously

Anonymous — Mon, 12 Dec 2016 12:05:15 GMT

Hi,

you can use the resident load,

Table3:

load

[Failure Date] - [Installation Date] as a variable

resident Table1:

resident Table2;

Re: Load data from Two or more Tables simultaneously

Anonymous — Mon, 12 Dec 2016 14:55:18 GMT

Thank You very much, but, is in this case better the double resident load (if it really exists) if the map is not used in anywhere else?

Re: Load data from Two or more Tables simultaneously

Anonymous — Mon, 12 Dec 2016 14:55:53 GMT

Thank you very much, but this code is not accepted by my QV :S

Re: Load data from Two or more Tables simultaneously

Anonymous — Tue, 13 Dec 2016 03:22:03 GMT

Ok,

after applying resident load......

you got any error message or

what is our error exactly?

and

why your application not accepted this,is there any reason?

Re: Load data from Two or more Tables simultaneously

Gysbert_Wassenaar — Tue, 13 Dec 2016 06:32:41 GMT

Why do you think you need a double resident load?

Re: Load data from Two or more Tables simultaneously

Anonymous — Tue, 13 Dec 2016 14:09:54 GMT

Well, the solution you propose is really good, but maybe I do not need to create a map table and by loading the data from the two tables at the same time is enough to construct by new variable. Actually is just the most obvious (but maybe not the best) option to pick the data from the two tables.

Re: Load data from Two or more Tables simultaneously

Anonymous — Tue, 13 Dec 2016 14:13:12 GMT

Qlikview does not liked it and just load the first table. I tryed with " : " and " ; " on each of the statements but it does not work. Simply, when you write the code the "resident" words is not in blue and when you load qlikview tells you that he does not found the field related to the second resident.

Re: Load data from Two or more Tables simultaneously

Anonymous — Tue, 13 Dec 2016 14:32:35 GMT

Hello Eric,

I think,

this error means,

qlikview not allows the two resident statements in single table.(means we can't use the to resident statement side by side).

and

its better to combined the table1 and table2 as a single table(Table1)with using any join statement or with concatenation statement,

then use the resident load,

Table3:

load

[Failure Date] - [Installation Date] as a variable

resident Table1;

Thanq.

Re: Load data from Two or more Tables simultaneously

Anonymous — Tue, 13 Dec 2016 14:42:39 GMT

Yes, maybe It's that is not allowed. Thank You

Re: Load data from Two or more Tables simultaneously

Anonymous — Tue, 13 Dec 2016 14:50:28 GMT

If you achieve that after some time...you tag that in discussion.

Thnaq.