Data Comparison In Multiple Excel Files Using Worksoft Certify


In our daily work we come across some system data. There could be a situation where we need to compare one system data with another system data. In Worksoft certify we have a file compare option to compare two files. But the feature is feasible, if the file containing data is in sync. What we have data in excel and the data are not in sync?

So, lets understand the situation:

Worksoft Certify gives us the feasibility to automate the excel and that can be achieved using MS Office Excel automation. If there is a situation, we have three sets of data in excel to compare, how we can do that using excel automation.

Let’s take a scenario to understand it better. Suppose we have three systems (Workday, SAP, Salesforce) integrated in an organization. There are some workers available on the Workday system and those workers ID and some of the details are sync with all three systems. Every month we need to extract that worker data and compare whether all three-system data are matching or not.

Please find some of the sample data below:

Workday System Data:

Workday system data

SAP System Data:

Sap system data

Salesforce System Data:

Salesforce system data

The above all three-system data column name and number of columns are not exactly matching.

We need to compare Workday system data with other two system data with reference to employee ID.



Open workday data excel and save the data on .csv format. Import the .csv file into Recordset. Please find the below screenshot for object action and narrative.

workday data excel

Create compare process for workday data with SAP data and attach the Layout. Recordset (workday data imported) on parent level. Based on the workday recordset data compression will start. Take the reference of employee ID and find the row on SAP data sheet and then compare the other details e.g First Name, Middle Name, Last Name, Email ID address and National ID. Please find below screenshot for the step.

SAP Data

Store the comparison result into variable and end or process write into recordset. Similarly, we can compare the data with Salesforce data and write the result. Final process we can export the result file.

salesforce data

Leave a Reply

Retype the CAPTCHA code from the image
Change the CAPTCHA codeSpeak the CAPTCHA code

SOAIS - Worksoft Newsletter

To view on your browser, click here
Facebook Twitter LinkedIn
Dear Default Value,

Welcome to SOAIS Newsletter of September 2021!

Continuous Testing with Remote Execution
The speed of innovation continues to increase, driving rapid and relentless change for today’s ever-evolving IT landscapes, creating greater risk as IT and business teams scramble to ensure timely delivery. How can your organization keep pace? Test more, worry less. With Worksoft’s Connective Automation Platform, you can easily build and maintain automated tests, accelerating testing time without losing scope or volume. You can schedule and execute remote, continuous tests to intercept defects sooner and prioritize remediation - without sacrificing your nights and weekends. Explore how continuous test automation and remote execution can empower your organization.

Click here to connect with us to get more information on our services.

Skip Costly Rework with Dynamic Change Resiliency​

Change resiliency is imperative in ever-evolving IT environments. Our patented object action framework streamlines change management by assigning object definitions to your shared assets. The same object may be used in a thousand automation steps, but it can be easily updated by making one simple change to the model definition. The change automatically propagates to every single instance where that object may have been used without a single line of code or manual human involvement. For more change readiness you can also engage our Impact Analysis for SAP to predict how changes in SAP transports will affect your business processes. 

Please click here to watch the video to get a gist.

SOAIS Blog – Nuts and bolts of Certify Database Maintenance​

One of the key thing, which is often missed by the organizations, who have invested in using Worksoft Certify for automating their Business Process Validation initiatives, is implementing a Database Maintenance Plan. While the business and the test automation consultants get excited about the shiny new thing that they have got and start building the regression suite; planning and executing a database maintenance plan for most of the customers gets pushed down the priority list. However, since all the test assets in Certify are stored in a Database, a robust database maintenance plan is very important to maintain smooth operation of Certify with acceptable performance criteria. The customers usually start facing issues once they have built significant number of Certify processes which they have started executing on regular basis. Such executions add a lot of data to the tables storing results data and increase the overall size of the Certify database.

Please click here to read the complete blog.

Worksoft Blog – Process Intelligence: A Multi-Dimensional Approach

The ability to extract process knowledge has become easier through the years. Technology has evolved to the point where we can deploy capabilities that connect at multiple levels to extract different types of process insight. In the past, organizations were forced to spend enormous energy extracting data manually from different applications and databases. Then, they would have to use things like spreadsheets to transform the data and convert it into meaningful information. 

Please click here and read the complete blog.
Unit 9, Level 5, Navigator, ITPL,
Bangalore - 560 066.
Phone: +91 80 40071234
Suite 101, 1979, N Mill St,
Naperville, IL 60563
Phone 1-800-262-2427
Please click here to Unsubscribe / Unsubscribe Preferences

Leave us your info