Delta/difference on the basis of dates

Venky_1992

How to make dynamic workflow to find unmatched records of some columns on the basis of consecutive dates.

In the below screenshot
For UserID A Delta is 1 as all column value for UserID A on date 02/02/2023 is not matching with previous 02/01/2023 date
but Delta is 0 as all column value for User ID A on 2/3/2023 is matching with previous 02/02/2023 date

Note: Not all dates are in sequence

Kindly Help me in this

delta.PNG

testcase.xlsx

Workflow

Developer

Designer Cloud

Output

Common Use Cases

Best Practices

Accepted answers

All comments

alexnajm

Not sure I follow your logic - it looks like you want the "Delta" to change to 1 every time a new date comes up, and then back to 0 for that date... however, for 2/2 it stays as 1 for some of the values. What is the logic there?

Venky_1992

Please ignore 2/2 and consider highlighted that is userID A, yes I want to find Delta(compare two consecutive dates and if there is a change/missing then Delta is 1)

Venky_1992

Please ignore 2/2 and consider highlighted that is userID A, yes I want to evaluate Delta(compare two consecutive dates and if there is a change/missing then Delta is 1)

alexnajm

Done!

Delta difference on the basis of dates.yxzp

Venky_1992

I think you have just compared the dates not the values of the column!!

alexnajm

Yes, because that's what you said - "(compare two consecutive dates and if there is a change/missing then Delta is 1)". So I am still not clear on your logic - you can either make it more clear or use the workflow already built to update yourself!

alexnajm

Update: I re-interpreted your logic to look at the Score Card field. In future posts, I would make clear what columns need to be a part of the logic to get the quickest and most accurate help

Delta difference on the basis of dates.yxzp

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703