Stagging List

Options
g.mahesh
g.mahesh Member, ALL USERS, Certified Model Builder Posts: 4 Occasional Contributor
in Planning & Modeling

Hi Team,

 

Please help me with the below requirement,

 

I am using two list items

1. Product List  (Stagging List with Hierarchy)

Ex:

Capture.PNG

2) Key Products(Flat List)

Ex: Having only one Product: PRODUCT A

 

In the Product Hierarchy list, I am maintaining one attribute called Key Product ? with the boolean format.

 

Now, in Product Hierarchy "Key Product?" attribute should tick. Whatever the PRODUCTs exit under "Key Product" list those list item should TRUE others FALSE.

 

I am using FIND ITEM Function but it's not working because the PRODUCT list is a numbered list and this list has duplicates.

 

Please suggest the same.

 

Thanks and Regards,

Uma

 

Tagged:

Categories