Checking row condition based on some column and save result as a new file.

Hello guys,

I'm pretty new to Alteryx, so far I was doing good but here I got stuck.

I'm attaching a file below where I want to apply condition on few columns and separate the "School" column values based on it. Conditions are mentioned in the table below:

Column Name	32 Questions	28 Questions
P9	1,2	3,4,5
P11	3,4,5	1,2
P17	1,2	3,4
P18	1,2	1,2,3
P25	1,2	3,4,5
P26	1,2	3,4
P27	3,4,5	1,2
P28	1,2,3	1,2

All conditions mentioned in the table should be meet Suppose if column P9 has values 1,2 it is 32 Question and if 3,4,5 than it is 28 Question row and so on for the other mentioned in the table. I want to separate all the rows based on 32 and 28 questions based on the above table condition.

So there is gonna be two files one for 28 questions and another for 32 questions.

Can also add a new column naming "Questions" and say 28 and 38 questions based on the condition for a single file.

Any help would be greatly appreciated. Thanks in advance.

***UPDATED***

Schools.xlsx

Datasets

Transformation

Accepted answers

Qiu

@sumitrathore
So this is what you need?

New Workflow3-r2.yxzp

All comments

echuong1

I'm a little unclear regarding what you are trying to accomplish. Are you able to post a sample "end output?"

If you are trying to get a count for each value based on that criteria, you can do something like this:

New Workflow3.yxzp

sumitrathore

This looks good and I might use it for some of my problems but this is not what I'm looking for.

So basically you used the if-else, where 1,2 is 32 Question and 3,4,5 are 28 Question but its checking condition for all the columns and giving the count. I want to separate the file based on the condition that I have mentioned in the table above to the 32 and 28 questions.

Sorry for the confusion.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703