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

Finding Certain Dates

josephcsmithny
5 - Atom

I have a large data file containing customer numbers, corresponding revenue and date of transactions.  How can I analyze the data to compile the first date of transaction for each customer number? (i.e., a particular customer number may have multiple transaction dates, however I'm trying to compile the first date of transaction for each customer).  

 

Thanks,

Joe

2 REPLIES 2
MarqueeCrew
20 - Arcturus
20 - Arcturus
Use the summarize tool.

Groupby customer number
Min transaction date

That will get you the earliest date. You can join this output back to the raw data and find the details by matching on cust number and date.

You could get multiple rows if there are multiple transactions on a date. You might need to summarize the raw data to get total of transactions on each date.

Cheers,
Mark
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
jdunkerley79
ACE Emeritus
ACE Emeritus

I'd probably do it the same way as @MarqueeCrew

 

But an alternative is:

- Use a Sort Tool - and sort by Customer Number and then Date of Transactions

- Use a Sample Tool - pick the first 1 record grouped by Customer Number.

Labels