How to look into previous three row values to Current Row in Alteryx

Question

How I can get the following expected output in Alteryx.

The scenario is for each account we need to look into IS_DEFAULT Column prior three observations and if 1 is there in any of the previous three observation we need to get result as 1 else 0.

Group by the account id and if needed we can use order by MONTH_SINCE_DISB and then for each account id we need to look into prior three observations if 1 is there in any of the three observations for that account id then the new column label should be marked as 1 else 0. Iteratively the same logic should be applied for all Account_Id.

IraWatt · Answer

Did not know that was a feature @ChrisTX ! Much better solution :D

ChrisTX · Answer

One Multi-Row Formula tool should do the trick.

Chris

How to look into previous three row values.yxmd

IraWatt · Answer

Hey @karthik-1237,

Maybe not the most advanced way to do this but you can do something like this:

Essentially each multi row formula group by ID and grab the row hind each other. If you have any issues make sure to ask :)

HTH,

Ira

Just updated it with your column headers!

Lots of Multi Rows.yxmd