Create a column using data from multiple sources and multiple if conditions

[pranee_007]

Hi Team,

I am trying to accomplish below workflow based on multiple looped conditions. I have already S1 in my workflow. I want to bring in S2 and S3 only for vlookup purpose into workflow. Please help me accomplish the logic in the attached picture. I have made a new column with the logic stated in the picture and added the column in S1. I want to use alteryx for implementing the same. I guess this is little compliacated and I am new to alteryx . Please help.

Main: Already in Alteryx workflow
Code	Level	Roll Number	Reference	New Column
a	1	92468		ab234
b	2	92205		er345
c	2		Unidentified	Unidentified
d	3		Unidentified	Unidentified
e	2	92206	Unidentified	Unidentified
f	1	92485		en567
g	1		Unidentified	Unidentified
h	3		en909RYT	en909
i	1	89088		not required
j	2	92207	en546DSK	en546

S2- Needs to be loaded in Alteryx workflow
Roll number	Supreme	Cheat
92468	43	ab234
92205	232	er345
92485	32	bc890

S3: needs to be loaded
Roll number	X	Y	Enterprise
92485	de	rt	en567
92776	43	54	en290

[rafalolbert · Accepted solution]

Hi @pranee_007,

Here you go, the workflow is attached to my post.

My new calculated field is called 'new_col' and at the end i compare it to 'New Column' from S1 - i think you've made a mistake for record with 'Code' as 'f' value, please see below:

Thanks,

Rafal

#Excuse me, do you speak Alteryx?

[pranee_007]

Thank you so much. I used your logic with some modifications and it worked.