Data blog RSS

Compare Excel Spreadsheets

Comparing Excel Spreadsheets - Why? Business and Data analysts, Developers and QA testers often have to verify their data is correct. Microsoft Excel is used to create a snapshot of "good data". Reports are captured and copied into Excel, data is exported and distributed as the model to use. SelectCompare allows you to compare Excel spreadsheets in the same way as other data sources. This post is going to show you the process of creating data connections to Excel workbooks and comparing data between two spreadsheets. Hava a look at the Excel data comparison use cases - there is plenty more! Where do I start? First, you have to install appropriate driver to connect to the Excel workbooks. It is an easy...

Continue reading

SQL Data Comparison - User Manual

You visit this page because you know how to write a SQL query. Learn how you can use your expertise to do your work better and save your time! The Idea The SelectCompare idea is very simple: write an SQL query to extract data to compare on each data source. With SelectCompare, you create comparison projects that define data connections to each of the data sources and you write SQL queries for these data connections. You can create data connections separately from comparison projects, and reuse data connections in multiple projects. This is a quick manual that will show you how to compare data using SelectCompare. Step by step When you launch the program, you are presented with the page containing all defined comparison projects. Initially...

Continue reading

Installing SelectCompare

After you download SelectCompare installer, when you try to run it, Windows may warn you about running the downloaded program. The warning dialog looks differently on various versions of Windows, but the way it works is similar. The default button cancels execution of the installer. Here's how it looks on Windows 10: In order to execute the downloaded installer, you have to click "More info" link.  The second dialog box shows information about the creator of the installer, in our case Maycove Studio Ltd, the creator of SelectCompare. In order to run the installer, you should click "Run anyway" button. The installation will proceed as usual. You may receive additional warning from UAC that the program is going to make...

Continue reading