Discussion Board for collaboration on QlikView Scripting.
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]
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.
If you want you can use a mapping table and the applymap function. See this blog post: Don't join - use Applymap instead
after applying resident load......
you got any error message or
what is our error exactly?
why your application not accepted this,is there any reason?
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.
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.
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).
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,
[Failure Date] - [Installation Date] as a variable