In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Count of variables in multigrouping

ievpal
7 - Meteor

Hi everyone,

 

I haven`t been able to solve this problem for a few days now. I have a data set that needs to be grouped and have the count of how many times this variable appeared in this group as shown bellow. However, everytime I try to group these variables and when I try to find the count of these variable I can only find a right count for Var1.

 

Sample input data set:

undefined

 

 

Required result:

undefined

 

Thank you.

 

3 REPLIES 3
pcatterson
11 - Bolide

I believe what you want to do is a series of summaries and subsequent joins.  Is this what you were looking for?

ievpal
7 - Meteor

Thank you. It`s more than I had.

But it would still be very nice to have Var1 mentioned only once, like we can have in pivot tables. Is that even possible? :)

pcatterson
11 - Bolide

You can make the duplicates NULL but there isn't a way to merge cells like you've visualized.  That would be applying a hierarchy to the data.

Labels
Top Solution Authors