Consecutive entries using multi-row tool (reverse order)

Consecutive entries using multi-row tool (reverse order).yxmd

Please find the below expected output.

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

Amended Consecutive entries using multi-row tool (reverse order).yxmd

Got it, so we can expect as many values of 10 to 15 etc.

I have amended the workflow to work in such a way it will dynamically work for huge values also.

I have sample checked with 6 values and the output is as expected. Could you please test the same with your huge dataset too.

I have modified only this area.

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

alteryx consecutive example.xlsx

All comments

I got the essence of the issue. To understand it better, can you please share the input and the expected output separately.

Will be easy to figure out the best possible solution.

Many thanks

Shanker V

@mtqromain

I cannot use the MultiRow tool to reference the same column with the row below (row +1 on desired output column), as it seems to only work with row -1.

FYI, multi row formula can be used for more than row-1 and row+1.

For that you need to increase the highlighted.

Please see the below.

Hope this helps!!!!

thanks for the reply!

Basically a simplified version of the inputs and outputs would look something like this (see excel file for reference):

input:

Ouput:

thanks for your help!

alteryx consecutive example.xlsx

@mtqromain

Got the necessary information, Thanks.

Consecutive entries using multi-row tool (reverse order).yxmd

Please find the below expected output.

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

Thank you very much for your help, this is great! especially the part with temp PEF and temp PSF, it will be very useful for other formulas in the future!!

Happy new year

Welcome, glad my solution helped for your future too. Happy new year!!!

Actually, I am still facing a difficulty: it seems to work for small number of consecutive collaborations, but it does not work if it is above 3. Do you have any idea how I could fix it?

I just built the solution based on the sample shared.

Could you please let me know how many consecutive collaboration is maximum.

Can work according to that and propose the solution/idea.

Many thanks

Shanker V

Maximum can be any value, sometimes i can have 10,15 or more consecutive values. Is there any way to account for that?