Discussion
Merge two field or more on Report Definition
Can anyone help me. I have one grid that shown below.
| First Name | Mid Name | Last Name | Full Name |
| Neymar | da Silva | Junior | |
| Lionel | Andres | Messi |
Data retrieved from external database by mapping tools and displayed by Data grid with source Report Definition. The question is how to merge First Name, Mid Name, and Last Name to be placed in Full Name field. Thank you.
Pegasystems Inc.
IN
Hello Yudhi,
Thanks for your post.
From your post, below is my understanding: Is this correct?
Hello Yudhi,
Thanks for your post.
From your post, below is my understanding: Is this correct?
| Current Grid | Expected Grid | |||
| .pyFName | .pyMidName | .pyLName | .pyFName + .pyMidName + .pyLName | |
| First Name | Mid Name | Last Name | Name | |
| Neymar | da Silva | Junior | Neymar da Silva Junior | |
| Lionel | Andres | Messi | Lionel Andres Messi |
PS: For product related query, kindly post it on https://collaborate.pega.com/question/pega-product-support-webhook-api
Regards,
Rincy
None
RU
Hello!
To do so, I created Function Alias Rule with 2 parameters. Your can update this code for 3 parameters.
CASE
WHEN ({1} IS NOT NULL AND {2} IS NOT NULL) THEN CONCAT ({1},' ; ',{2})
WHEN ({1} IS NOT NULL AND {2} IS NULL) THEN {1}
WHEN ({1} IS NULL AND {2} IS NOT NULL) THEN {2}
ELSE 'Values are missing’
END
first condition: combines the values 1 and 2, if they are not empty
second condition: return 1 value, if 2 is empty
third condition: return 2, if 1 is empty
and "Else" return message.
I'm sure there are other better decisions, but you can use it.