Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

General Discussions

Discuss any topics that are not product-specific here.
SOLVED

Support to Group Data based on 2 condition

Diemm
8 - Asteroid

Hi Alteryx Community,

 

I would like to request some help to figure out something that I'm working on.

 

I have my data where i have a vendor name column, another column with some folios and some other columns.

 

I'm trying to use a tool that help me to count the number of recods that i have based if the vendor is the same and have the same folio, but I cannot find how to solve this.

 

Example:

 

Columa Vendor I Column folio I Desire count

001                             01                  2

001                             01                  2

001                             02                  1

001                             03                  1

002                             01                  2

002                             01                  2

002                             02                  2

002                             02                  2

003                             01                  1

 

Do you have any ideas to solve this?

 

Thanks community

2 REPLIES 2
Qiu
21 - Polaris
21 - Polaris

@Diemm 
I think you can get much response if you post on the Design Channel.
Anyhow, I believe we can use the Tile tool for your purpose.

0818-Diemm.PNG

Diemm
8 - Asteroid

Thanks @Qiu 

 

After a while i was able to find the answer and it was exactly as you solved this.

 

Really helpful, cause sometimes i get confused with that title tool functionality.

 

Note: i have another issue now that i just posted in the designer channel (i guess) thanks for the tip on this too

 

Thanks

Labels
Top Solution Authors