Remove the Duplicates from the Pagelist using Data Transform.
Hi,
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..!!
Accepted Solution
Updated: 12 Jul 2020 12:44 EDT
Infomatics Corp
US
The reason why DT is throwing Exception because the function pyRemoveDuplicatesFromPageList doesn't have any return type. Follow the below steps to copy the data into New Property after removing the duplicates from Page List
1. Set Param.RemoveDuplicates = @pyRemoveDuplicatesFromPageList(pyWorkPage,"OldAccountsList","AccountNumber")
2. Use AppendTo Method .NewAccountsList and Select the Relation as "For EachPage In" and Source as .OldAccountsList
Accenture
IN
Hi @AbhilashK7565
Thanks for your reply.
Tried with the same steps you suggested, But the Data Transform is still showing the same error message.
Pages and Classes Tab:
Page: pyWorkPage, Class: Jaguar-Triumph-Work-Bank
PageList: NewAccountsList (Jaguar-Triumph-Work), Page Definition: Jaguar-Triumph-Data-Bank
PageList: OldAccountsList (Jaguar-Triumph-Work), Page Definition: Jaguar-Triumph-Data-Bank
Could you please help out what exactly I'm missing..?
Incessant Technologies Pvt.Ltd
AU
Hello,
Based on the error it is trying to find the valid function. As there is no valid rule set and library associated with the function it is throwing that error. Generally we will get this error if we copy past the function. Can you please try selecting the function and providing the parameters by using expression builder.