Inter Record Concatenation

[kangaroomac]

Hi All,

I have an interresting challenge. I have 2 fields: FieldName and FieldDescription. I would like to concatenate all occurences in FieldDescription where FieldName is the same. Is this possible?

I have attached a sample.

Thanks to all who tries.

[whiteline]

Oh, that is not so interresting...

You can do it

1) In a load script:

LOAD

     FieldName

     Concat(FieldDescription) as  FieldDescriptionConcatenated

RESIDENT YourInputTable;

2) Or in Chart:

Create a Chart (straigth table) with  dimension FieldName.

Use as expression: =Concat(FieldDescription)