Posts

How to Compare CSV Files or Compare a CSV File to a Database Table


CSV files are a quick and convenient way to record structured data in a generic format. Because CSV files are so easy to create, multiple similar versions of very large CSV files can quickly proliferate. Often it becomes necessary to compare CSV files to find the desired version. In an ETL (Extract Transform Load) scenario, a data analyst may want to compare a CSV file to a database table for validation or to update data.

DiffDog, the unique XML-aware diff / merge tool from Altova, supports CSV as a native file format for comparison and can compare and selectively merge data CSV to CSV, or between a CSV file and database table. Let’s look at an example.

Read more…
Tags: , , , ,

Version 2020 Revolutionizes JSON Editing


We’re introducing several exciting new tools for JSON development in Altova Software Version 2020, but there’s much more too. Support for the XULE XBRL standard, comparing CSV against database content, and updated database support are just a few of the new features introduced across the product line.

Let’s take a look at the highlights.

Altova Software v2020 announcement
Read more…
Tags: , , , ,