community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

Creating formula to identify change based on record id

Meteor

Hello,

Is there a way to have a column created that identifies when a change occurs in data based on sorted date and another column. The data is grouped by building and sorted on date. I want to count if a change has occurred. For each building I want to calculate the number of color changes based on the sorted date.

Example

Data set

BuildingColordate
23G12/16/2015
23G1/17/2016
23R2/18/2016
23G3/1/2016
56R3/1/2016
56G3/12/2016

 

 

required outcome

 

BuildingColorDateChange
23G12/16/20150
23G1/17/20160
23R2/18/20161
23G3/1/20161
56R3/12/20160
56G3/1/20161
Highlighted
Alteryx Alumni (Retired)

You would use the Multi-Row Formula tool and create an expression that compares the color in the current row with the color in the previous row (i.e., Row-1) and group by building.

Meteor

Thank you... After playing around, I found the tool at the same time you responded...

 

It was in front of me the entire time.

 

ha ha :-)

 

 

 

Labels