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

Identifying product order sequence

Archi
5 - Atom

Dear Alteryx Community,

 

I've been enjoying many of the great answers around here since I started my Alteryx journey this year and now is finally the time to ask for help myself, as I cannot seem to Google my way to the answer!

 

I'm hoping to get any kind of help to figure out how to solve my problem.

 

I have a dataset containing:

 

- order data

- specific product

- dates of purchase

 

I'm interested in giving each product an "Order #" based on date of purchase So the first order (based on date of purchase) would be numbered #1 and so on. What I hope to get as a result is something like this:

 

Example.PNG

 

Any help or input would be greatly appreciated.

2 REPLIES 2
yalmar_m
11 - Bolide

Dear @Archi,

 

Nice of you to start working with Alteryx,good luck using this wonderful tool.

I would advise you to use the multi-row formula. 

 

You find a suggested workflow attached.

 

Best,
Yalmar

Archi
5 - Atom

That worked like a charm. 

 

Thanks @Yalmar! 

Labels