Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

IF Contains

beatrizmguerreiro
8 - Asteroid

Hello, 

 

I have a dataset similar to this and need to:

* Count the number of rows with the word "Fruit" and "Carbs"

* Sum the amount of requests, per type - also, need the date record as well

* Sum the price, per Type - also, need the date record as well

 

Date

TypeAmount of requestsPrice
01/01/2020Fruit Banana2010
03/01/2020Fruit Apple3010
01/01/2020Carbs Pasta1015
02/01/2020Carbs Rice1015

 

Can you help me?

 

Thank you 🙂

5 REPLIES 5
JulioMO
9 - Comet

Hi @beatrizmguerreiro 

 

I've attached a workflow that performs what you want.

 

Hope it helps!

 

Regards

Qiu
21 - Polaris
21 - Polaris

@beatrizmguerreiro 

How do you want the Date Record to be shown for a Sum operation?

beatrizmguerreiro
8 - Asteroid

@JulioMO 

 

It's working well. However, in my result I still can see different rows for Fruit Bananas and Fruit Apple. I needed these "merged" together", as fruit

JulioMO
9 - Comet

In the second browse tool , you will see the results in the "merged form", since you are grouping by the Type_II field. That's the results you are looking for. 

 

However, if you want more details, in the third browse tool, you are also grouping by Type.

 

In your case, to see the results in the required form, you just need to pay attention to browse tool 1 and 2.

Qiu
21 - Polaris
21 - Polaris

@beatrizmguerreiro 

Like this format

Capture46.PNG

Labels
Top Solution Authors