Support to Group Data based on 2 condition

[Diemm]

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

[Qiu · Accepted solution]

@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.

[Diemm]

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