c# Data Quality and Cleansing Automation for Kuldeep
$25-50 USD / hour
Completed
Posted over 8 years ago
$25-50 USD / hour
I need an example procedure written in C# .NET which I will be integrating into an existing web application.
The goal of the procedure is to evaluate 'rules' against a dataset to check the quality of the data. If a rule fails, it will be output to the user at the end
We need to effectively run two different types checks as part of this sample and we may need to get into more complex scenarios going forward. The types of checks we need to run:
1. Is A > B (and derivatives of this i.e. A >= B, A < B, A <= B, A=B,A!=B)
2. Is A+B > C or SUM(A,B) > C
If a rule is passed, we don't need to see any output.
If a rule fails, we would need to add it to a list and see a consolidated list of failures at the conclusion of the check.
Sample Data:
I've attached two tables in the file. One with data which should allow you to run these checks. You should import this into the application as json (see [login to view URL] attached for the same data converted to json) or similar.
Using this data, you need to implement the Rules checks on the 'Rules' tab of the Excel file.
This should not be hard coded. I need the ability to pass fields to any functions etc so I can make these checks dynamic in the future.
In your bid & proposal, please discuss a little about how you think you would solve this problem. Do you have experience implementing such algorithms in a dynamic manner? Also, please discuss how long you think this will take you and when you are able to start.
I will award this project quickly if someone shows they are able to complete and start quickly.