Concatenation of a field order by a value in a different field

[#1]

Hello,

I've the following table:

FIELD A (NOKEY)	FIELD B (NONOTA)	FIELD C ( RIGA)
LI11703020120117000000001	XXX	10
LI11703020120117000000001	YYY	20
LI11703020120314000000010	AAA	10
LI11703020120314000000010	BBB	20
LI11703020120314000000010	CCC	30

The concatenation of the FIELD B should follow the order of the FIELD C for the distinct value of the FIELD A

How do I give this indication to the function used? The function used is the following:

aggr (Concat (DISTINCT NONOTA, ''), NOKEY)

But I get a concatenation unordered for the field B and it's wrong.

I would like to have the following string in output AAABBBCCC  while I get the following string AAACCCBBB.

Thanks.

[marcus_sommer]

concat() had a third parameter for sorting but it must be a numeric one.

- Marcus

[#3]

Hi,

please try....

=NOKEY&NONOTA&RIGA

it will concat and all field.

[#4]

It's possbile to use a name of a field as a third parameter ?

If not, how can I order for the FIELD C ?

I do not understand what is the logic with which the strings are concatenale.

[#5]

I would concatenate only the value of the FIELD B for the distinct value of the field A order by FIELD C.

[#6]

could you please text an example on you real data which you posted, so I can understand

[#7]

This is a summary of the table that I read

FIELD A (NOKEY)	FIELD B (NONOTA)	FIELD C ( RIGA)
LI11703020120117000000001	XXX	10
LI11703020120117000000001	YYY	20
LI11703020120314000000010	AAA	10
LI11703020120314000000010	BBB	20
LI11703020120314000000010	CCC	30

I would have a result like this

LI11703020120117000000001                              XXXYYY

LI11703020120314000000010                              AAABBBCCC

In same case I obtain this result:

LI11703020120314000000010                              AAACCCBBB

Thanks

[#8]

Hi,

I have used same formula, which you have applied and it is working fine.

=aggr (Concat (DISTINCT nota, ''), nokey)

please find the attachment.

[marcus_sommer]

Try: Concat (DISTINCT NONOTA, '', RIGA)

- Marcus

[#10]

Hi Rakesh, I've tried bue the problem is still present.

I don't understand how can I attach a file in the discussion, if is possible I attach a file that explain the problem.