Alteryx designer Discussions

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

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

Highlighted
Meteor

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  
CodeLevelRoll NumberReferenceNew Column
a192468 ab234
b292205 er345
c2 UnidentifiedUnidentified
d3 UnidentifiedUnidentified
e292206UnidentifiedUnidentified
f192485 en567
g1 UnidentifiedUnidentified
h3 en909RYTen909
i189088 not required
j292207en546DSKen546

 

S2- Needs to be loaded in Alteryx workflow
Roll number SupremeCheat
9246843ab234
92205232er345
9248532bc890
   
   
   
   
   

 

S3: needs to be loaded   
Roll numberXYEnterprise
92485derten567
927764354en290

 

Pranee_007_0-1573039674285.png

Bolide
Bolide

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:

 

image1.JPG

 

Thanks,

Rafal

 

#Excuse me, do you speak Alteryx?

Highlighted
Meteor

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

Labels