Hierarchy from transactions

Hi! @takbb @evert.homan_scilifelab.se

You both helped me with the hierarchy transaction building workflow, and I tested this today first time with real live data.

Result of running the workflow was 1.4 million iterations and a runtime on 20-30 hours (estimate) :smiley: I don’t see any way of making this to run faster, but would either of you have any ideas? :smiley:

I have attached the model and the example data.

hierarchy builder.knwf

hierarchy test.xlsx

@takbb Almost there I used the Top Parent hierarchy search_Ipazin model. [image] Couple of issues, first being that the starting point in the results is not always the TOP level (the level that does not have any Parent IDs, in example should always start with ID, not IDC) and also, it prints the between paths also (first 2 rows in the results). Any ideas :)?