Question
BOA
IN
Last activity: 10 Jun 2022 5:23 EDT
How to iterate and copy data in a data transform using 2 pagelists
HI All,
I am trying to achieve below requirement using data transform but unable to progress. Please suggest.
I have a data page which calls a data trasnform , this will call a report definition to fetch data on to a page list RIFWork. Now my requirement is i have to iterate on RIFWork and check some criteria , if the criteria matches then that particular record in iteration should be coped to my source i.e data page.
I wrote ForEachPageIn to loop on RIFWork.pxResults
Added when rule to check criteria
Now when i try to copy to data page i am unable to. PFA screen shot.
I am getting nothing on data page.
***Edited by Moderator Marije to add Capability tags***
Accepted Solution
Updated: 10 Jun 2022 5:23 EDT
BOA
IN
@Pavani_Regulagedda Issue is resolved. PFA screen shot.
Updated: 9 Jun 2022 11:41 EDT
UnitedHealth Group Incorporated
IN
@Pavani_Regulagedda Select the check box "Also use each page as source context". This will copy from RIFWork.pxResults to the Data Page, else it will treat Current source as Data page only as its inside when(you can check same on tracer).
Hope this helps!
PS: Able to see error mark on Primary.pxResults...are you getting any error while saving?
JPMC
IN
@Pavani_Regulagedda Can the condition be placed directly on the report filter and give this report as direct source to datapage?
UnitedHealth Group Incorporated
IN
@BhanuPrakash_G Yes, if the results fetched only from the report you need on data page, then you can source from report definition and have the report definition filter out records.
Accepted Solution
Updated: 10 Jun 2022 5:23 EDT
BOA
IN
@Pavani_Regulagedda Issue is resolved. PFA screen shot.