"IF" condition based on multiple criteria - Alteryx

Anjankumar2021

Hi, pls assist on the below.

Input:

Table A

Student	Total Marks
Samsung	55
LG	33
Onida	18
Sony	8

Table B

Min	Max	Rank	S.No
0	0	R0	1
1	5	R1	2
6	10	R2	3
11	20	R3	4
21	30	R4	5
31		R5	6

any student with greater than or equal to 31 marks considered as rank R5 .

Required output:

Student	Total Marks	Rank	S.No
Samsung	55	R5	6
LG	33	R5	6
Onida	18	R3	4
Sony	8	R2	3

cjaneczko

Try the following

if [Total Marks] = 0 then 'R0'
elseif [Total Marks]>= 1 and [Total Marks] <=5 then 'R1'
elseif [Total Marks]>= 6 and [Total Marks] <=10 then 'R2'
elseif [Total Marks]>= 11 and [Total Marks] <=20 then 'R3'
elseif [Total Marks]>= 21 and [Total Marks] <=30 then 'R4'
elseif [Total Marks]>= 31 then 'R5'
else Null()
endif

Then Join the Rank to the Table to get the S.No