How to update value of the previous row based on conditional statement?

How can I update/change the value of the previous row based on an IF statement? I'm using a multi-row formula tool to flag records that match on date (if date matches then 1 else 0) but it only flags the current record. I also want to flag the prior matching record as well.

Is this possible and if so, how??

Thanks!!

Shahab

Best Practices

Transformation

Preparation

Accepted answers

afv2688

Hello @sheidari ,

You can use the following formula:

IF [Row+1:Date] = [Date] OR [Date]=[Row-1:Date] THEN 1 ELSE 0 ENDIF

Regards

multi row.yxmd

messi007

@sheidari,

Oh my bad yes, I updated the formula accordingly

Attached the workflow,

Regards,

Multi_20210308.yxmd

All comments

messi007

@sheidari,

Could you share a sample data with the expected output? It will help us to give you the expected solution.

Regards,

sheidari

Here you go, @messi007 !

Current Output
Name	Date	Code	SameMonthFlag
John Doe	11/1/2018	1111	0
John Doe	11/2/2018	1112	1
Jack Johnson	12/1/2019	1100	0
Bob Jones	2/1/2020	1024	0
Bob Jones	2/1/2020	1027	1

Expected Output
Name	Date	Code	SameMonthFlag
John Doe	11/1/2018	1111	1
John Doe	11/2/2018	1112	1
Jack Johnson	12/1/2019	1100	0
Bob Jones	2/1/2020	1024	1
Bob Jones	2/1/2020	1027	1

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703