Hi to everyone,

I have a problem with aggregation.

I want to aggregate elements of a subset of a table.

Each subset is composed of 100 rows.

In each row there is a set of elements that could be duplicates.

I’d like to create a set of elements that contain, for each row, all the elements that there are in the previous rows.

In the following an example:

RowID0 | [a,b,c] | [a,b,c]

RowID1 | [a,b,c] | [a,b,c]

RowID2 | [a,c,c,e] | [a,b,c,e]

RowID3 | [a,b,c,d,e] | [a,b,c,e,d]

RowID4 | [c,f] | [a,b,c,e,d,f]

.

.

.

RowID99 | [z,j,z,y] | [a,b,c,e,d,f, … ,z,j,y]

RowID100 | [1,90,w] | [1,90,w]

RowID100 | [a,b] | [1,90,w,a,b]

ecc.

Can, someone, helps me?

Thanks,

Andrea