Rollup Min & Max values in hierarchy

[ashishshetty]

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!

[apathetichell]

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

[Qiu · Accepted solution]

@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.

[Qiu · Accepted solution]

@ashishshetty 

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. 😁

[ashishshetty]

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?

[Qiu]

@ashishshetty 
Try to follow the instructions here.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-downgrade-yxmd-Workflow-yxmc-Ma...

[ashishshetty]

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