Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

need Help !! Multi row formula

Rakesh_Jasuja
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

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.

11 REPLIES 11
MilindG
12 - Quasar

Have you tried row+2?

JosephSerpis
17 - Castor
17 - Castor

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_30092022.JPG

Rakesh_Jasuja
8 - Asteroid

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

actually I will share a workflow for reference. 

Rakesh_Jasuja
8 - Asteroid

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
8 - Asteroid

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

Rakesh_Jasuja
8 - Asteroid

Hi @JosephSerpis 

I have attached the actual workflow row.yxmd

MilindG
12 - Quasar

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

Rakesh_Jasuja
8 - Asteroid

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

Rakesh_Jasuja
8 - Asteroid

@MilindG  @JosephSerpis 

the output should return 008188 in job_code column.

Labels