Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Validating data based on ranges defined in database

hima_shar
8 - Asteroid

Hi All,

 

I have a scenario where I have to validate my data against the ranges defined in database.

My Input data looks like-

 

Employee table

EmployeeIDRoleAgeSalary_in_INRNo_Of_Team_members
1Team lead351000005
2Manager3915000020
3Developer30750000

 

Ranges for columns are defined in a database table like below.

 

Range Table

RoleParameterLower_LimitUpper_Limit
Team LeadAge2545
ManagerAge4055
DeveloperAge2035
Team LeadSalary_in_INR50000150000
ManagerSalary_in_INR100000200000
DeveloperSalary_in_INR25000100000
Team LeadNo_Of_Team_members04
ManagerNo_Of_Team_members1050
DeveloperNo_Of_Team_members00

 

Based on the ranges defined in the table , I have to perform checks whether values like Age, Salary and No_Of_Team_members are in the range of lower and upper limit.

 

In above example record of employee id 1 is not valid as he has been assigned 5 team members but upper limit is 4 as defined in range table

Employee id 2 is also not valid because age is not in the range. Only employee id 3 is valid record and should be populated in target. I need to send first two records in error table.

 

Can you pls help me achieve this?

 

Regards

Himanshu

 

 

2 REPLIES 2
MarqueeCrew
20 - Arcturus
20 - Arcturus
Please join the two tables on ROLE. Then the limits can be viewed on each employee record. You can then check easily against the limit values.

Cheers,

Mark
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
hima_shar
8 - Asteroid

Thank you @MarqueeCrew

 

Labels