Discussion Board for collaboration on QlikView Scripting.
I have the following problem:
I have two tables:
Now I want to load the two tables, so that I get one table (Table1) with the following result:
Can anyone help me!
Go to Solution.
See the solution sheet by the use of LastValue( ) you can achieve it.
Load a data some thing like
load * inline
LastValue(Amount) as LastVal,
group by Date;
drop table Table1;
If you not require Table1 so drop it or if you want to keep it so do not delete it.
Just simpley load this two tables.
when I'm only load the two tables, I get the following result:
But the Amount 2 on 02.10.2011 must be overwritten by Amount 5 on 02.10.2011 from table2.
thank you very much for the example and the quick answer!!
That's the solution.