Concatenate data

[StixStax]

Hi,

i have data on a databand which comes out this way:

Text1: Person A
Text2: Person B
Text3: Person C
...

I would like to concatenate this data and have the output in one text:
Text1: Person A, Person B, Person C

Do you have an idea how I could accomplish this?

[Jan]

Hello,

You can use following expression in text component if PersonA, PersonB and PersonC is a fields of the one data row:

Code: Select all

{Person A} {Person B} {Person C}

Please contact us if you need any additional help.

Thank you.

[StixStax]

Hey Jan,

Its the same field in the data structure, where Person comes from.

I added sample data to show what my desired output should look like. I need to concatenate the strings from the same data field as shown in the last cell at the bottom of the page (all countries). Do you have an idea how to get rid of the rest of the cells?

[HighAley]

Hello.

If you need to join values from the same column and different records, then you could use next expression:

Code: Select all

{Func.EngineHelper.JoinColumnContent(Countries, "CountryName", ",")}

Thank you.

[StixStax]

Exactly what I needed. Thank you so much. Thank you for your fast reply

[HighAley]

Hello.

We are always glad to help you.

Thank you.

[StixStax]

Hi,

do you have an idea how to exclude same strings? I do not have the textfield on a databand.

[HighAley]

Hello.

Please, describe your scenario more detailed.
What do you need to exclude and by what condition.
Could you send us a sample report template with data?

Thank you.

[StixStax]

In the following example "Andorra" is listed multiple times. How can I change the report, so I can only see it once?

[HighAley]

Hello.

You should create a Data Source from other data source with grouping on duplicating column. And then use it in the JoinColumnContent function.

Please, look at the attached report template.

Thank you.