Concatenate a property of page list in Data transform
I have a requirement of concatenating all the notes added by the user to a property. User can add any number of entry. I need to implement this in a Data transform.
***Edited by Moderator Marije to change Content Type from Discussion to Question; added capability tags***
Updated: 23 Jan 2023 5:58 EST
JPMC
IN
@AshishA94 Can you check if ootb function pxStringCSVFromPageList helps.
e.g., @pxDataManipulate.pxStringCSVFromPageList(.pyTableSource.pxResults, ".pyClassName")
Updated: 23 Jan 2023 5:58 EST
Empower Retirement
IN
@BhanuPrakash_G Hi Bhanu, Is not it will work for comma separated? I just need to display as a complete string.
Updated: 23 Jan 2023 5:58 EST
JPMC
IN
@AshishA94 If you need to concat all the notes by any other character other than comma(,) i guess the only way is to loop over the pagelist and append it.
Something similar to this:
Updated: 24 Jan 2023 5:45 EST
Pegasystems Inc.
IN
@AshishA94 try this below which first converts the document notes to csv with comma separated within in the double quotes then replacing the comma with space and finally replacing double quotes with empty @replaceAll(@replaceAll(@pxDataManipulate.pxStringCSVFromPageList(.pyTableSource.pxResults, ".pyClassName"),","," "),"\"","")