Concat for only possible value

[nboccassini]

Hi,

I have 2 fields not connected cointain same data (B is a field of a large table )

A
1
2

B	C
1	x
2	y
3	z
4	q

I need a concat function to show values from A that are in possible value in B.

For ex. I select y and z in field C, the possible values of B are 2 and 3 --> The concat function will be retrieve 2

Thanks

Gabriele

[pradosh_thakur]

=concat({<A=P(B)>}A,',')

[nboccassini · Accepted solution]

It doesn't works if a make a seleciton on A.

I've tried this and now works:

=Concat({$*$<A=p({<B=>}B)>}Distinct A,'"|"')

[pradosh_thakur]

great!! I thought you only want selection in B which is the only thing you mentioned in the question. Cheers.. :):)

[evandroaps]

perfect! thanks