Skip to main content

Comparing Datasets for Changes

I'm migrating data to a new system in the near future which involves mapping existing data to the data fields in the new system.

I want to be able to compare the data migrated into the new system to that which was exported from the old and flag up any changes.

In theory the two datasets - one imported to the new system (exported from the old) and one exported from the new should be identical.

Is there any way to do this in IDEA?  The only kind of compare I can see wants to total a field whereas I want to look for differences amongst all fields.

Thanks.

Brian Element Tue, 12/13/2016 - 07:16

Hi Algecan,

You are correct, the compare function in IDEA is somewhat limited.  You might want to check out my script that helps get around these limitations.  The two files will have to have one or more common fields to do the compare.  http://ideascripting.com/Compare-multiple-fields