Inspire EMEA 2022 On-Demand is live! Watch now, and be sure to save the date for Inspire 2023 in Las Vegas next May.
Announcement | We'll be doing maintenance between 2-3 hours, which may impact your experience. Thanks for your patience as we work on improving the community!

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer and Intelligence Suite.

need Help !! Multi row formula

8 - Asteroid

Hi All,


I have dataset where I need to compare 1st row with 3rd row. I am trying to compare it with using row+1 = Row-1 but it is not giving expected results. can anyone help please?


here is an example




output should be true if row 1 (2022) and row 3 (2022) have same value.

This is part of dataset and as per the requirements I have to use data as it is, and I don't have to sort it.

16 - Nebula
16 - Nebula

Hi @Rakesh_Jasuja had to create a new column and then rename it to achieve the output you desire.

8 - Asteroid

Hi @JosephSerpis  thank you so much for sending the workflow.

this seems to be working, however there are 24 column  where this need to be applied, also I need to test this out in actual data. Which includes additional scenarios.


I will make those changes during weekend and will reply once it is working.


Thank you so much for your help.