Question
General Electric Company
IN
Last activity: 30 Jun 2017 3:10 EDT
How to concatenate 4 property for a join condition on a Report defination?
HI All,
On the join condition on a RD I need to concatenate 4 property, I tried using the + sign to concatenate but it does not work. Is there any other way to concatenate properties for a join condition on a RD. EX - "StringA-"+.Property1+"-"+PN.Property2+"-"+.Property3+"-"+.Property4 . The example way have already been tried and it did not work. If anyone can suggest an alternate approach.
***Moderator Edit: Vidyaranjan | Updated Categories***
Coforge DPA
GB
Hi DurgeshP0263,
Use Function alias in your report definition to get the concatenated values, In Function alias have this sql query CONCAT ({1},{2},{3},{4}).
{1},{2}....are parameters to the function, in your case properties.
Incessant Technologies
IN
Hi,
You can use function alias in your Report Definition to achieve this. Below link explains about the usage of Function Alias.
https://community.pega.com/sites/default/files/help_v722/procomhelpmain.htm
Hope this helps.
Regards,
Mallikarjun