Iterate through each row with multiple rows in multiple columns

Question

Hi all,

Can you please help me?

I want to iterate each row of start Dist with all rows in columns- (Length, Dist and Depth) and calculate the max depth based on conditions and groups.

I have around 5000 groups and checking even though it's possible to do in Alteryx. Attaching an example herewith.

Example.xlsx

pri_GIS · Answer

Thank you so much @AdamR_AYX for dedicating your time and your effort to it. I appreciate your great solution.

pri_GIS · Answer

Thank you so much @AdamR_AYX  for your response. I am checking the solution and let you know.

AdamR_AYX · Answer

I'm not sure if I quite understand what we are calculating, but I think I can replicate it in Alteryx like so

DepthCalculations.yxmd