Top parent hierarchy search

KNIME Analytics Platform
22

Hi @bruno29a

I understand now. Certainly a possible alternative. Thanks for the explanation :blush: !

Best

Ael

23

Hi @ipazin

I had never used the -Cell Replacer- node so didn’t know about it. Very useful to know and certainly the best solution. Thanks @ipazin :smiley: :+1:!

Best

Ael

24

Tnx @aworker and @bruno29a!
Cell Replacer is really useful and one of my favorite nodes. And if once gets improvements like wildcards and regex it will supernode :slight_smile:
Ivan

25

Hi @ipazin , indeed, I can see that. Like @aworker , I’ve never used it before. It’s a very useful node.

26

@ipazin Just a comment about the loop stop criteria. Your recursive loop stops at a fix arbitrary number of iterations which is larger than the number of rows. The number of rows is a better upper bound since the loop should not iterate more than the number of rows (i.e. the number of nodes in the graph). This is still an upper bound which could be lowered to the minimum number of iterations. This can be done using as condition that the LevelUp column had not changed compared to its previous values, as follows:

image
image1407×321 104 KB

Could the condition checking be implemented with less nodes :thinking: ? Please suggest. I’m curious :wink:

Best

Ael

27

Hello @aworker,

the number of rows is indeed better upper bound if not building stop criteria. For a stop criteria I was using similar approach and needed 4 nodes but had different workflow design (no Rule Engines outside loop and one Rule Engine was inside loop to give entire path which led to parent) which allowed me to aggregate on last column to count missing values and stop based on it. Your approach seems better. Alternative that comes to my mind is as always scripting…

Br,
Ivan

28

Hi @ipazin

Thanks for the explanation. I appreciate it.

Best

Ael