need Help !! Multi row formula

[Rakesh_Jasuja]

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

2022

2020

2022

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.

[MilindG]

Have you tried row+2?

[JosephSerpis]

Hi @Rakesh_Jasuja you need to increase the rows on the Multi Row tool to tackle that challenge. Have mocked up a workflow that demonstrates this.

[Rakesh_Jasuja]

Thanks @MilindG , honestly speaking, I was not aware about +2 will try for sure.

actually I will share a workflow for reference. 

[Rakesh_Jasuja]

Hi @JosephSerpis  thanks for quick reply.

actually the data set will only have 3 records per ID.

i will share a workflow soon.

[Rakesh_Jasuja]

Hi @MilindG  I have attached the actual workflow row.yxmd

[Rakesh_Jasuja]

Hi @JosephSerpis 

I have attached the actual workflow row.yxmd

[MilindG]

@Rakesh_Jasuja Can you share the output you're trying to get please?

[Rakesh_Jasuja]

@MilindG the output is in Excel format. I have added browse tool for reference.
hope this helps

[Rakesh_Jasuja]

@MilindG  @JosephSerpis 

the output should return 008188 in job_code column.