Counting value occurrences in a column and take the most frequent occurred value

Hi guys,

I am trying to count the value of date occurrence for each client name and take the most frequent occurred values. If the occurrences number is the same then can take the earlier date. Basically, the year 2020 will be in the Interim column and 2021 will be in Final column.

I have attached the file and image of input and output below.

Thanks so much for your help in advance!

Alteryx_question.xlsx

Datasets

Developer Tools

Tips and Tricks

Best Practices

Accepted answers

atcodedog05

Hi @HungCuong_HCM

Here is a workflow for the task.

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

final.yxmd

All comments

atcodedog05

Hi @HungCuong_HCM

Here is a workflow for the task.

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

final.yxmd

Jonathan-Sherman

Hi @HungCuong_HCM,

This is the perfect use case for a summarise tool, you'll want to create three actions.

(1) Group By - [Client Name]

(2) Min - [Start Date]

(3) Max - [Start Date]

The group by action will create a unique list of each of your "Client Names", whilst the Min and Max actions will extract the start and end dates for each of those client names.

If this solves your issue please mark the answer as correct, if not let me know! I've also attached my workflow for you to download if needed!

Regards,

Jonathan

20201116 - MinMaxValues.yxzp

atcodedog05

Happy to help 🙂 @HungCuong_HCM

Cheers and Happy Analyzing 😀

HungCuong_HCM

Thank you very much! It solved all of my requirements. 🙂

HungCuong_HCM

Thanks for your answer! There are a few additional requirements in my exercises too. Anw another person has the solution for me. Thanks!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15881

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703