need Help !! Multi row formula

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.

row.yxmd

Help

Data Investigation

Accepted answers

All comments

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.

Multi_Row_30902022.yxmd

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.

JosephSerpis

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

row.yxmd

Rakesh_Jasuja

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703