Hi all, aggr(concat()) problem

[#1]

Help gurus! 

I do something wrong? Why value is null for 2 bottom rows?

many thx!

[#2]

Hi!

What result do you want to get?

[Gysbert_Wassenaar]

I don't understand what you're trying to do. It doesn't make sense to me. What is the result you expect?

[maxgro]

I think

aggr is by @1 

@1 has 2 values

so you get a virtual table with 2 rows,

one row for @1=1 and the second for @1=2

[#5]

aggr is by @1 column, so its values are (1,2) then the result would be 2 rows.

If you want to have te next result:

     Mark     20,333

     Peter     11,11

     Steve     50,231

     Ilya        123

Then the aggr is by @ 2

If it helps?

[#6]

If it so, i think the second table sows results only for @1=1 and the third column is just hardcoded 1. So the third column (expression) can be calculated for each @2, whereas you don't have @3 values for ilya and peter, so you have nulls/ If you remove third column, NULLs will disappear

[#7]

Oh god sorry please, my mistake, another screen is actual, i need result:

1 Mark 11,20,231,50

1 Peter 11,20,231,50

1 Steve 11,20,231,50

2 Ilya 11,123,333

2 Mark 11,123,333

2 Peter 11,123,333

Value is a concat of all @3 group by @1, but for every @2

[maxgro · Accepted solution]

concat(total <@1> @3,'.')

[#9]

Thx!