topic Inter Record Concatenation in QlikView

Inter Record Concatenation

kangaroomac — Tue, 04 Sep 2012 08:51:42 GMT

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.

Re: Inter Record Concatenation

whiteline — Tue, 04 Sep 2012 09:00:03 GMT

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)