hierarchy list and child list

hi!

When I check list items in the parent hierarchy, I want to create a mechanism to check all items in the child hierarchy.

What i should do?

Please help me.

Accepted answers

Vinay VaradarajM

Hi @KubotaNatsuki ,

In your query, assuming 'Check' = assigning ✅ to a list item in parent list, you can Lookup the parent property (which @ChrisAHeathcote explained) to apply it to child items pertaining to that parent.

Regards,

vinayvm

All comments

LipChean_Soh

Hi @KubotaNatsuki

You'll need to provide more information.

I find that a working sample on Excel that you attach here normally helps.

Thanks,

LipChean

ChrisAHeathcote

@KubotaNatsuki

Create a module dimensioned by the child list.

Add a list formatted line item containing the parent list.

Use; ITEM(PARENT('Child List')) to pull through the parent of the list item.

Now you can see the parent of each child list item in a single location. If a child list item does not have a parent then the result will be blank.

Vinay VaradarajM

Hi @KubotaNatsuki ,

Regards,

vinayvm

Misbah

@ChrisAHeathcote

Shouldn't it be PARENT(ITEM(Child List))?

Misbah

ChrisAHeathcote

ha!

Yes you are right.

KubotaNatsuki

Thank you for your reply!

I got it to use Lookup!!
Thank you!!

KubotaNatsuki

Thanks for your reply!

I can do it to use 'Lookup' and 'Parent' function!
Thank you so much!

ChrisAHeathcote

@KubotaNatsuki

While using LOOKUP will return the parent list item as per a mapping module dimensioned by the child item but the formula will not be as efficient as using PARENT.

Quick Links

Can you help?

Unanswered questions

Azure SQL Connection, database name with Hyphens in Data Orchestrator
I am attempting to connect to an azure SQL database vis at the MSSQL connector in data orchestrator but am having issues and I believe it is due to hyphens in database name (which is a fairly standard naming convention I will note!) Example below (fake credentials) - has anyone else encountered similar and is there a way…
12.4.1 Activity: Create Saved View for Non Employee Expenses
Hi, for some reason my shipping costs are the same over every month and I don't know what to do to fix it.
Workaround for Formula & Closing Balance summary methods together in Polaris
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…