Can we add summation Data in Qvd / Backend??

[#1]

Hi all,

PLease if any one can help me out on this problem.

I have 50,000 row and 23 fields in my daily_table.

I want to load the data such that row's remain 50,000 only and the 23 fields data get sum up for next day.

[#2]

PLease help .......

i have use Concatenate but it increas fileds to 100000 next day ....

Will group by work on this. ??

[googel84]

Hi AshwinPagare, the only strategy I can think about is the following and, considering that you are not talking about am extremely large amount of data, I'm confident that you won't experience performance problems.

1. Load the "old" table (let say you name it "DATA")
2. Load and join the "new" table to the "old" one (you'll get a unique internal table called "DATA")
3. Reload "DATA" into a new table called "DATA_NEW" creating new colums to sum up fields coming from the two original tables
4. Delete "DATA"

Hope it helps.