Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Pooja Palla (PoojaPalla)
Publicis Sapient
Pega Senior System Architect
Publicis Sapient
IN
PoojaPalla Member since 2018 28 posts
Publicis Sapient
Posted: Jan 25, 2023
Last activity: Jan 27, 2023
Posted: 25 Jan 2023 10:42 EST
Last activity: 27 Jan 2023 3:30 EST
Closed
Solved

Concatenate 2 properties in Report Definition

Hi, 

I have a page CustomerDetails in my pyWorkPage which holds two properties CustomerFirstName and CustomerLastName

I have a table with a source as a report definition. The table should display a column CustomerName which is ("CustomerFirstName" + "CustomerLastName") as its value

Is concatenation possible in Report Definition?


***Edited by Moderator Marije to change type from Pega Academy to Product***
To see attachments, please log in.
Pega Platform 8.5.4
Case Management
User Experience
Reporting
Senior System Architect

Accepted Solution

Posted: 3 years ago
Updated: 3 years ago
Posted: 25 Jan 2023 21:14 EST
Updated: 27 Jan 2023 3:30 EST
Aruldevan Thangappan T (ArulDevan)
NCS Pte. Ltd
Aruldevan Thangappan T
NCS Pte. Ltd
SG

Hi @PoojaPalla- Yes it is possible. You can use Concatenate report function.

Please note that the results of function will be available in a embedded page (like pyTextValue).

Thanks.

To see attachments, please log in.
Posted: 3 years ago
Posted: 27 Jan 2023 3:30 EST
Pooja Palla (PoojaPalla)
Publicis Sapient
Pega Senior System Architect
Publicis Sapient
IN

Hi @ArulDevan,

Thanks for your response and time. Your suggested approach is working.

In Edit Columns of Report Definition

In Column Source, click on the "fx"(calculation builder) button and search for concatenation

Report Definition Concatenate

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice