Here is another challenge for you!
This one follows the previous one: ✓ RPA Challenge 26 - Structured Data Validation
So once you are ready with Challenge 26, you are ready to move on to this Challenge number 27!
The goal is the same: Let robot mark in red highlight all errors in the input file.
Include those from Challenge 26 + add these checks on top:
|5||ErrorCode||Must match one of the Error codes in Sheet ErrorCodes|
|6||ErrorName||Must match one of the Errror Names in Sheet ErrorCodes|
|7||Registered||Must contain YES or NO|
|8||If column Registered is YES, then column RegisteredBy must be filled in and vice versa (If column Registered is NO, then column RegisteredBy must be filled in)|
|9||If Result = APPROVED, only column ApprovedBy must be filled in, RejectedBy must be empty (and vice versa, for REJECTED)|
Here is the input file: InputData.xlsx (14.0 KB)
- Send me your code in PM
- Post in Reply: Excel sheet with results (highlighted errors)
First three correct, original solvers earn 3 robopoints, next get 1 robopoint.
There is a leaderboard with your score. Those on top positions will be badged by a special challenger badge
The challenge deadline is 26.9. by the end of the day. You can still submit your projects after the deadline but you cannot earn robopoints. A new challenge is published every week or 2 weeks so don’t worry if you did not catch this one. Keep in mind, your submitted files may be published after the deadline so others can learn from solutions.