Concat values for only flag with minimum value

[kushalthakral]

Hi All

i have a requirement where i need to concat values where we have minimum flag associated with the Id values like in below table 

Id	Sub ID	Flg
A	A1	1
A	A2	2
B	B1	2
C	C1	2

For Id A, i have two values one for flg 1 and one flg 2, in case of Id B i have only one value of flg i.e 2 

So i need to concat A1,B1 and C1 based on minimum values of flag for associated Id's

I hope my question is making sense

Thanks in advance

Kushal

[rubenmarin · Accepted solution]

Hi, if possible i would flag the min values of each id in script so you only need:

Concat({<MinFlag={1}>} [Sub ID])

If not I think you will need an aggr and an if, like: =concat(Aggr(If(Flg=Min(TOTAL <Id> Flg), [Sub ID]),Id,Flg) ,',')

[kushalthakral]

Thanks, that is what I was looking for

Thanks for your efforts and Help

Cheers 

Kushal