Hello!!
I'm a fairly new Alteryx user who knows the basics. I have a set of test product data attached, basically I have multiple products with unique account numbers that differentiate the product. Each product can change behaviour (i.e. column A in the attached TEST DATA file) within multiple rows by month. Though no month column should have the same account twice as one product can only be a certain type at a certain time (defined by column C which is product type).
What I'm trying to do is:
1) Combine unique accounts into one row that then shows the movement in that one account
2) Adding an identifier (based on column C) to each account by month to show its type
3) The end goal is then to identify when and only when, a product moves from Fixed type to SVR type.
4) Then by account, I need data to show how many months AFTER fixed that a product was SVR before it changed or no longer existed. Note I only need to know this for fixed t0 SVR, all other variations don't matter i.e. rows 14 and 15 are the scenario to map, excluding the others i.e. I don't care about SVR to fixed regardless of when this happens.
The dream is then say for a massive list of products where I can identify for products following that trend, for how many months they stayed SVR after fixed.
Any help really appreciated love the community and have taken so many solutions from this so thanks for your time.
