Question
Zensar Technologies Ltd
IN
Last activity: 14 Jul 2024 10:04 EDT
Copying Specifice ID pages from One Pagelist to Another Pagelist in Data Transform
Hi All, I have 2 pagelists.
Products <---- Pagelist
Product(1) = ProductID = 1, ProductName = "Router" <--- Properties inside Pagelist
Product(2) = ProductID = 2, ProductName = "Switch" <--- Properties inside Pagelist
Feedback <---- Pagelist
Feedback(1) <----------- ProductID = 1, Comment = "OK" <--- Properties inside Pagelist Feedback(2) <----------- ProductID = 1, Comment = "Good" <--- Properties inside Pagelist Feedback(3) <----------- ProductID = 1, Comment = "Best" <--- Properties inside Pagelist Feedback(4) <----------- ProductID = 2, Comment = "Average" <--- Properties inside Pagelist Feedback(5) <----------- ProductID = 2, Comment = "Poor" <--- Properties inside Pagelist I want All pages where ProductID = 1 of Feedback Pagelist to be added inside Products pagelist Product(1) as a new Pagelist. And same all page of ProductID = 2 of Feedback Pagelist to be added inside Products pagelist Product(2) as a new pagelist. How we can achieve this using data transform. Thanks,
Aaseya IT Services Pvt LTD
SA
You can use the "IsInPagelist" function over feedback pagelist. Where you product ID matches Product 1, append to Product 1 pagelist and same for Product.
IsInPageList("ProductID1","ProductID",Primary.Feedbacklist)
You can check similar condition in a when step or when rule and when this is true, you can append to Product 1 pagelist. You can do the same in otherwise scenario for Product 2.
If you have more than 2 Product list, better to perform the entire operation in Product pagelist.
1. Loop over Product list
2. Copy the current Product ID in some parameter.
3. Check the logic with IsInPageList("Param.ProductID1","ProductID",Primary.Feedbacklist)
4. Append the results in the current Product pagelist if above condition matches.