How to concatenate two strings in calculated field?

eset_janata · August 24, 2018, 9:51am

Hi,

how can I concatenate two strings in calculated field? I just need to add a special prefix to an existing string field. Your documentation is silent about this.

Thanks,
Radek

malikgp · August 24, 2018, 7:00pm

[Measures].[String 1 example] || " " || [Measures].[String 2 example]

You use || for appending, and can add any delimiter you choose. In the example above I used a space as the delimiter.

Hope this helps.

– Malik Graves-Pryor

martins.vanags · September 12, 2018, 1:45pm

Hi,

Please try the approach @malikgp shared.

Thanks!
Best regards,