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.

@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?

@Pavani_Regulagedda Can the condition be placed directly on the report filter and give this report as direct source to datapage?

@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.

@Pavani_Regulagedda Issue is resolved. PFA screen shot.