Need Help

[#1]

Hi Community,

See below image,

I have 1 execution date and OrderAge field...

when i am reload tomorrow i want add date and OrderAge

EX

Key        CoverageStatus         Execution_Date      Order_Age

asd          True                            2/12/2014              1

pasd         False                         2/12/2014               6

when i am reload tomorrow  i want add 2 columns  and Order_Age Increasing with +1

like this

Key        CoverageStatus         Execution_Date      Order_Age     Execution_Date        Order_Age    

asd          True                            2/12/2014              1                          2/13/2014                  2

pasd         False                         2/12/2014               6                         2/13/2014                  7

Thanks in Advance......................

[Gysbert_Wassenaar]

Since you have only one Order_Age per date you can use max(Order_Age) or min(Order_Age) or avg(Order_Age) or sum(Order_Age) or only(Order_Age). Any of these will do. See attached qvw.

[aveeeeeee7en]

Check this.