Concatenate strings for distinct values

[#1]

Good morning, I have the following situation:

I have a code in column A and a column B with a field tha contains NOTES.
The field A may be repeated on multiple lines with different values of NOTES.

I need to have for each distinct value of the field A concatenation NOTES present in field B.

How can I do this?

Thanks

[alexandros17]

Fields A and B are in the same table?

If the answer is yes then:

Load

   ...

   A & B as myNewField

   ...

resident mytable;

let me know

[MarcoWedel]

Front end:

Chart with

Dimension: colA

Expression : concat(distinct colB)

[#4]

Hi guys, sorry but I don't understand.

The fields A and B are in the same table.

The table is the following:

NOTE00F:

LOAD

    NOKEY as [NUMERO CHIAVE],

    NONOTA

...

...

...

[anbu1984]

Can you post sample data and expected output

[#6]

FIELD A (CODE)		FIELD B (NOTE)
LI11703020120117000000001		XXXXXXXXXX
LI11703020120117000000001		YYYYYYYYYY
LI11703020120314000000010		AAAAAAAAAA
LI11703020120314000000010		BBBBBBBBB
LI11703020120314000000010		CCCCCCCC

I expect that the results is:

LI11703020120117000000001	XXXXXXXXXXYYYYYYYYYY
LI11703020120314000000010	AAAAAAAAAABBBBBBBBBCCCCCCCC

[anbu1984]

Load

FieldA,

Concat(FieldB,'')

From

Table

Group by FieldA

[jonathandienst]

Hi

That's what Marco's code should produce. With the correct field names this is (in a straight table):

Dimension: [NUMERO CHIAVE]

Expression: Concat(DISTINCT NONOTA)

HTH

Jonathan

[jmmayoral3 · Accepted solution]

You can use this expression:

=aggr(concat(distinct FieldB,''),FieldA)

[#10]

Hello guys, The concatenation should follow the order of the field C.

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

How do I give this indication to the function used? The function used is the following:
aggr (Concat (DISTINCT NONOTA, ''), NOKEY)

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

Thanks.