Gyan Dahal (YangD245)
Tata Consultancy Services

Tata Consultancy Services
YangD245 Member since 2017 31 posts
Tata Consultancy Services
Posted: November 29, 2018
Last activity: November 29, 2018
Posted: 29 Nov 2018 6:21 EST
Last activity: 29 Nov 2018 11:51 EST

Conditionally copy Pages into a PageList

There are two pagelists say GrandFatherPage.pxResults and FatherPage.pxResults. The property ID in Grandfateher pagelist can have the common value with the property FID in Father Pagelist. There are multiple pages in Father Pagelist that have common value for the ID of a Page in GrandFather Pagelist.

I would like to copy all the properties from a page of Father Pagelist based on the following conditions.

  1. The GrandFatherPage().ID equals the Father().FID


  2. If the Father().Status has value equals to “Fail”, copy from the first occurring page.


  3. If the Father().Status does not have “Fail” in any of the pages, copy from the last occurring page.

  4. If above conditions (1 AND 2) OR (1 AND 3) are not true, no page should be copied.

What configurations in data transform resolve it? Thank you in advance. I have attached sample screenshot from clipboard.

Data Integration Java and Activities
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.