Question

5
Replies
1503
Views
YangD245 Member since 2017 31 posts
Tata Consultancy Services
Posted: 1 year ago
Last activity: 1 year 9 months ago
Closed

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

    AND

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

    OR

  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
Share this page LinkedIn