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

Returning the sequence of customer purchases for each customer

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

Highlighted

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

Hi Kaviyarasan,

 

Thanks! You are my hero!

 

Herman

Labels