Rollup Min & Max values in hierarchy

Hello!

I am trying to rollup min & max values through each level - from child levels up to parent levels.

For example, here is the input structure:

Here is the result:

Any help is appreciated. Thanks in advance!

Macros

Help

Accepted answers

@ashishshetty
I use a Batch Macro to do it.

but for the "AAA-B11B-1147" should be null for Min and Max, since it does not have any child.

It also took me quite a while to get there, which I assume it should be answer here.
Maybe this would make a good weekly challenge idea?

I am sending a few to Alteryx, but apprently they get annoyed by me and no response for couple weeks. 😁

I clearly didn't read this carefully enough - great job @Qiu

@ashishshetty
I use a Batch Macro to do it.

but for the "AAA-B11B-1147" should be null for Min and Max, since it does not have any child.

It also took me quite a while to get there, which I assume it should be answer here.
Maybe this would make a good weekly challenge idea?

I am sending a few to Alteryx, but apprently they get annoyed by me and no response for couple weeks. 😁

Thank you @Qiu! This might be the right solution but unfortunately I cannot open it 😞 (I have Alteryx 2020.2)

Is there a way to export the solution in version 2020.2?

@ashishshetty
Try to follow the instructions here.

Thank you very much Qiu! This is exactly what I was looking for. Really appreciate your help!