CONCAT with Aggr

[robert_mika]

Having this INLINE set

LOAD * Inline

[

Month,Group,val

1,A,1

2,A,2

3,A,3

1,B,4

2,B,5

3,B,6

1,C,7

2,C,8

3,C,9]

I'm, getting

15/24/6

when evaluating

CONCAT(Aggr( sum(val), Group))

The number are right but (and please correct me here) should not that be

6/15/24

[anbu1984]

CONCAT(Aggr( sum(val), Group),'/',Aggr( sum(val), Group))

[jonathandienst]

Hi

I think concat uses load order, so I would have expected to see A/B/C in your results. You can ensure the load order by doing an inline load of just Group, in the required order, before you load the detail. The first load of a field determines the load order. That might work.

HTH

Jonathan

[MarcoWedel]

Hi,

one solution could be:

=CONCAT(Aggr( sum(val), Group),'/',FieldIndex('Group',Group))

hope this helps

regards

Marco