Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Returning the sequence of customer purchases for each customer

cheunghm4532
7 - Meteor

Dear Alteryx experts,

 

I am trying to add a new column to indicate the sequence of purchases for each customer. I have tried tools like Running Total and General Rows, but it doesn't work for me. I have also tried the Multi-Row Formula tool, but it doesn't seem to work for my case. Does anyone know the solution? Thanks!

 

 

Help.png

 

Herman

2 REPLIES 2
Kaviyarasan_P
8 - Asteroid

Hi 

 

I have used the Multi-Row formula to get the answer to your question.

 

IF ([Row-1:Customer]!=[Customer] AND [Row-1:Transaction Date] != [Transaction Date]) THEN 1 ELSE (IF [Row-1:Transaction Date]=[Transaction Date] THEN [Row-1:Count] else [Row-1:Count]+1 ENDIF ) ENDIF

 

Multi-Row.JPG

cheunghm4532
7 - Meteor

Hi Kaviyarasan,

 

Thanks! You are my hero!

 

Herman

Labels