NagaSaiJ Member since 2018 16 posts
Tech Mahindra
Posted: July 11, 2020
Last activity: July 12, 2020

Remove the Duplicates from the Pagelist using Data Transform.


I've a requirement to remove the duplicates from one Pagelist and copy the unique items to another Pagelist using Data Transform.

Tried using pyRemoveDuplicatesFromPageList, but no luck.

Syntax used in DT is,

NewAccountsList = @Utilities.pyRemoveDuplicatesFromPageList(pyWorkPage,".OldAccountsList","AccountNumber")

pyWorkPage: Jaguar-Triumph-Work-Bank

My Old Pagelist is .OldAccountsList and it has a column AccountNumber.

OldAccountsList(1).AccountNumber = 111

OldAccountsList(2).AccountNumber = 222

OldAccountsList(3).AccountNumber = 333

OldAccountsList(4).AccountNumber = 111

OldAccountsList(5).AccountNumber = 222

After running the Data Transform, Expected Result should be,

NewAccountsList(1).AccountNumber = 111

NewAccountsList(2).AccountNumber = 222

NewAccountsList(3).AccountNumber = 333


But while saving the Data Transform, its showing an error.Attaching the Pic of it. Could anyone give some idea please..!!

Data Transform Error Pic

Pega Customer Service for Financial Services 8.3 Pega Customer Service for Financial Services Case Management
Share this page LinkedIn