Help with Ranked column (ranking based on IF statements in a loop)

[Anonymous]

Hi All, 

I'm trying to create a new ranked column based on a few if rules that need to be looped over. 

The data looks like this with the ApplicationCycle column being the desired ranked column: 

TABLE1

InteractionKey	Interaction	CourseTitle	Application Cycle
7	Application made	Master of Arts in Digital Asset and Media Management	1
9	Conditional Offer	Master of Arts in Digital Asset and Media Management	1
7	Application made	6-week Combined Pre-sessional Programme	2
15	Firmly accpt offer	Master of Arts in Digital Asset and Media Management	1
14	Enrolled	Master of Arts in Digital Asset and Media Management	1
21	Reject	6-week Combined Pre-sessional Programme	2
7	Application made	Pre-Sessional Course in English and Study Skills for Academic Purposes Stage 3	3
23	Unconditional Offer	Pre-Sessional Course in English and Study Skills for Academic Purposes Stage 3	3
15	Firmly accpt offer	Pre-Sessional Course in English and Study Skills for Academic Purposes Stage 3	3
8	ATRd	Pre-Sessional Course in English and Study Skills for Academic Purposes Stage 3	3
14	Enrolled	Pre-Sessional Course in English and Study Skills for Academic Purposes Stage 3	3
7	Application made	Master of Arts in Digital Asset and Media Management	4
9	Conditional Offer	Master of Arts in Digital Asset and Media Management	4
8	ATRd	Master of Arts in Digital Asset and Media Management	4
15	Firmly accpt offer	Master of Arts in Digital Asset and Media Management	4
14	Enrolled	Master of Arts in Digital Asset and Media Management	4

So far, from my understanding the code should be something like this: 

ApplicationCycle=

Start LOOP from first unranked row in [ApplicationCycle] :
Foreach(row in [InteractionKey]): 
IF([InteractionKey]= "7") START RANKX (TABLE1 , [InteractionKey])
IF([InteractionKey]= "7") again SKIP RANKX
IF([InteractionKey]= " 6,10,21,24,14") STOP RANKX
End LOOP

Any advice, tips and pointers to this will be much appriciated.  

Thanks, 

[v-xicai]

Hi @Anonymous ,

Could you please clarify what's the logic for the other InteractionKey Except the number "7, 6,10,21,24,14"?

Best Regards,

Amy

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.