Inspiration
When we talk about a banking/insurance company, it will be related to so many data Customer. From those many data, there will be a dump data which need to be erased/updated. That's why we created a robot that can detect a duplication data.
What it does
Robot will read the new Customer Data and New Transaction in excel file, then there will be a file checking whether robot already read that file or not. After that robot will check excel data and compare it to Existing database using some filtering and Jaro Winkler Logic. Robot will Listing all of the duplication Customer Data in an Excel File and separate the data whether it's duplicate, refer or not duplicate.
How we built it
We research for the most happening issues on the market/client and compare/analyze those issues to choose what robot that we are going to make. After that, we combine the rule policies to determine whether it's duplication or not based on our experience. And then, we start the development. We built it using OOTB Action from Automation Anywhere and there are many logical things such as Nested if or loop, but For Jaro Winkler, we download it from Bot Store.
Challenges we ran into
Determine policy rules for Duplication Client.
Accomplishments that we're proud of
We are happy to make a solution for most common issues in the market.
What we learned
There are so many things that need to be automated in this digital era.
What's next for Prevent File and Data DeDuplication
Make the File input and policy rules become more flexible, and Robot automatically update the duplication data into 1 valid Data in the system.
Built With
- rpa
Log in or sign up for Devpost to join the conversation.