Inspire EMEA 2022 On-Demand is live! Watch now, and be sure to save the date for Inspire 2023 in Las Vegas next May.
We'll be completing standard maintenance for our Single Sign-On system on November 30th 6pm Pacific Time for approximately one hour. During this time My Alteryx and sign-in functionality to all My Alteryx programs (Licensing Portal, Community, Beta Program, Case Portal, and others) may be inaccessible. Thank you for your patience.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer 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
11 - Bolide

Have you tried row+2?

JosephSerpis
16 - Nebula
16 - Nebula

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
11 - Bolide

@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