In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

How to assign the SCORE to a list of values, based on these score conditions?

Aakash55
7 - Meteor

Hello, I am trying to create a workflow in Alteryx by which I can Assign the SCORE to a list of values, based on the score conditions.

I have attached the sample data in an excel sheet.


On the top there is the table to score my value.
I need to score the items according to the Category and the Value

Example:

Items A
Category - 2
Value - 1606
Score - 3

Item B
Category - 3
Value - 1000
Score - 3

Please suggest me, which particular Alteryx Tools should be used in this workflow for getting the required solution. If you need any more clarifications, then do let me know.

Thanks a lot for your help.

 

 

Score Criteria.png

 

 

 

 

6 REPLIES 6
atcodedog05
22 - Nova
22 - Nova

Hi @Aakash55 

 

Here is how you can do it.

Workflow:

atcodedog05_0-1644325902170.png

 

Hope this helps : )

 

Qiu
21 - Polaris
21 - Polaris

@Aakash55 
Hope this helps

0208-BeingHappy.PNG

Qiu
21 - Polaris
21 - Polaris

@atcodedog05 
Amost same approach, but you are faster.

Just brushed my little girls teeth. 😁

Aakash55
7 - Meteor

Thank you so much @atcodedog05 and @qiu

 

You guys are super quick and provide very efficient workflows. Much Appreciated.

 

Best Regards

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @Aakash55 

Cheers and have a nice day!

Qiu
21 - Polaris
21 - Polaris

@Aakash55 
Glad to help and thank you for the accept mark!

Labels
Top Solution Authors