Discussion Board for collaboration on QlikView Scripting.
I load new data every day and need not just concatenate it to previous one, but also make changes in old data according to a new data. Here is an example of tables
load * Inline [
As a result of joining/concatenating them I would like to have
How can I do that?
Go to Solution.
Try loading in the following order:
where not exists(a);
Here it is:
LOAD * Resident A;
LOAD * Resident B;
DROP Tables A, B;
LOAD a, Max(b) as M Resident AB Group by a;
LOAD * Resident AB Where M = b;
DROP Table AB;
Can you try this
load distinct a, b
drop table A;
But what if values are not numbers, or number which become both less or more. In final table should be value from second load, not matter what there
Result will be
You mean the result should be Ordered??
I get exactly the way you asked for the code snippet post my me earlier. Plz. see the screen shot.
I meant that should be unique "a" values, and "b" values from the latest load
It works! Thank you.
Could you please explain how this "where not exists(a)" statement works here?