Count of undergrad students

Hey everyone since i am new on this community i just needed a small help from you guys.

I need to produce an output that gives the count of Under Grad students for each grade (e.g. A,B,C) who enrolled in "Introduction to database/Access" course.

I have attached the data sheets below.

Thanks in advance!!

Data Analyst Intern_SQL Test DB.xlsx

Join

Accepted answers

DavidP

Hi @Akash007

Welcome to the Community!

The problem looks like an exercise from a course. While I'm sure there are lots of people on this Community who would just give you the answer, you'll probably learn a lot more if you tried solving it yourself.

There are various bits of information in all 3 tabs of the sheet, so you need to link them all together, right? Can you identify a common field in all three tabs?

To solve this problem, I would look at the following tools:

Join

Filter

Summarise

You can find all those tools in the Favorites tool palette. A great tip to learn more about them is to look at the examples available for each tool when you click on them in the tool paltte.

Happy Alteryxing and and let us know if you get stuck.

deviseetharaman

Hi @Akash007

Please try this

deviseetharaman

Here is a simple way to do it

students.yxmd

All comments

DavidP

Hi @Akash007

Welcome to the Community!

There are various bits of information in all 3 tabs of the sheet, so you need to link them all together, right? Can you identify a common field in all three tabs?

To solve this problem, I would look at the following tools:

Join

Filter

Summarise

You can find all those tools in the Favorites tool palette. A great tip to learn more about them is to look at the examples available for each tool when you click on them in the tool paltte.

Happy Alteryxing and and let us know if you get stuck.

deviseetharaman

Hi @Akash007

Please try this

Akash007

Hey david thanks for helping me out ,i will surely try it

Akash007

How can i create a sample alteryx workflow which takes the attached excel file as an input?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703