Question
Tata Consultancy Services
Tata Consultancy Services
IN
Tata Consultancy Services
Posted: Jan 21, 2019
Last activity: Jan 22, 2019
Last activity: 22 Jan 2019 10:21 EST
Closed
Solved
How to Set property values as comma separated values when pagelist contains duplicates
Hi
When my PageList(1) Property contains duplicate values, have to set property of that pagelist values to another pagelist(2) by comma seperated.
Sample.pxResults(1): A="xyz",B="123" etc..
Sample.pxResults(2).A="xyz" ,B="abc" etc..
Have to set above two pages as 1 page values like CSV:
Final Output Required as: Test.pxResults(1): A="xyz",B="123,abc"
Accepted Solution
Posted: 6 years ago
Pegasystems Inc.
Pegasystems Inc.
IN
Hi Krishna,
Please follow below steps :
1.Copy Sample.pxResults to Test.pxResults
2.Use following function to remove duplicates from Test.pxResults "@pyRemoveDuplicatesFromPagelist(Test,"pxResults","A")"
3.Loop Test.pxResults and in property set take A value in a parameter(Param.Val=Test.pxResults(<CURENT>).A)
and Param.Val2="")
3.1 Inside Test.pxResults loop Sample.pxResults and in when condition check Sample.pxResults(<CURENT>).A==Param.Val
If it is true then continue and set Param.Val1=Param.Val2+","+Sample.pxResults(<CURENT>).B else exit iteration.
3.2 Test.pxResults(<CURRENT>).B = @whatComesAfterFirst(Param.Val2,',') (to remove first comma)
For more details refer attached screenshot
Regards,
Vinay Reddy
Posted: 6 years ago
Pegasystems Inc.
IN
Hello
Have you checked this post :
https://collaborate.pega.com/question/check-duplicate-pagelist-based-two-properties
Accepted Solution
Posted: 6 years ago
Pegasystems Inc.
Pegasystems Inc.
IN
Hi Krishna,
Please follow below steps :
1.Copy Sample.pxResults to Test.pxResults
2.Use following function to remove duplicates from Test.pxResults "@pyRemoveDuplicatesFromPagelist(Test,"pxResults","A")"
3.Loop Test.pxResults and in property set take A value in a parameter(Param.Val=Test.pxResults(<CURENT>).A)
and Param.Val2="")
3.1 Inside Test.pxResults loop Sample.pxResults and in when condition check Sample.pxResults(<CURENT>).A==Param.Val
If it is true then continue and set Param.Val1=Param.Val2+","+Sample.pxResults(<CURENT>).B else exit iteration.
3.2 Test.pxResults(<CURRENT>).B = @whatComesAfterFirst(Param.Val2,',') (to remove first comma)
For more details refer attached screenshot
Regards,
Vinay Reddy