Error handling in Hierarchy path

[Brent_Baldwin]

I currently create a number of Hierarchy files using excessive left joins. I do this to ensure I don't clip a hierarchy, as they can grow and shrink.

I wanted to streamline this process and move to the Hierarchy path action. The issue I have is that the parent-child file often has errors, and one of the errors I need to deal with are "pruned" parents. That is a child exists with a parent node, but the parent node has been removed.

Currently (I'm using v5.8 but couldn't see any updates in newer releases) the Hierarchy path action has no option (similar to iterate) to continue and append results:

Is it possible for the Hierarchy path to have the ability to note errors such as this, ideally still listing the parent node in the path then continuing on with other rows?

[dgudkov]

Hi Brent and welcome to the Community!

We've discussed your feature request internally and came to the conclusion that such an option is not really required, as the desired output can be achieved with a few additional steps.

The idea is to create dummy parents instead of the pruned ones to make the "Hierarchy path" action complete successfully. Then you can filter out the dummy parents.

See below an example:

pruned-parents.morph (5.3 KB)