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

Group By and Count

dhakim1996
7 - Meteor

Hi, I am interested to create a workflow where the following input will give the following output:

 

Input

Item CodeFYRevenue
ABC123191111
ABC123202222
ABC123213333
DEF45619-
DEF45620-
DEF456214444

 

Output

Item CodeFYRevenueRevenue Count
ABC1231911113
ABC1232022223
ABC1232133333
DEF45619--
DEF45620--
DEF4562144441

 

Any kind soul can help pls :)

 

Thank you in advance

3 REPLIES 3
binuacs
20 - Arcturus

@dhakim1996 One way of doing this

binuacs_0-1669633035180.png

 

DavidSkaife
13 - Pulsar

Hi @dhakim1996 

 

Here is a solution for you: Firstly Filter out where Revenue does not equal -, then group by Item Code and count Revenue. Join back to the main dataset on Item Code, and perform a quick calculation to remove any counts where Revenue equals -

 

DavidSkaife_0-1669633254153.png

 

ShankerV
17 - Castor

Hi @dhakim1996 

 

One way of doing this.

 

ShankerV_1-1669635631767.png

 

 

Output:

 

ShankerV_2-1669635667669.png

 

Kindly accept this solution if it provided a solution to your question.

 

Many thanks

Shanker V

Labels