Easy Data Transform v1.10.0
For Windows and Mac

This release adds bug fixes and improvements to v1.9.1. The download links are at the bottom of the page.

We recommend that you back-up important transform files before installing any new release. Please let us know of any problems or issues you encounter with the release.

You can uninstall old releases after you have successfully installed this version.

Windows and Mac

1. Previously file types were based on file extensions and could not be changed (e.g. .xml is always an XML file). You can now set the default file type for input and output files in the Preferences window.

Input and output file types

If you input a file with an unknown extension you will be prompted for the default type for this extension.

Set default file type from extension

You can also override the default file type for each input and output item using the Type option.

Set file type

2. The Dedupe transform has now been replaced by the more comprehensive Unique transform.

Unique transform example

Only rows that have unique values for every Keep unique column will be kept. For the other columns you can choose:

The Dedupe transform is now deprecated and can’t be added to new .transform files.

Thanks to João for the suggestion.

3. You can now uncheck add totals for a Pivot transform if you don’t want to add row and/or column totals. Thanks to Dan F. for the suggestion. (This feature was supposed to be in v1.9.1, but was accidentally omitted.)

Pivot without totals

Pivot with totals

4. The Lookup transform now has a If no match option so you can decide whether to Use no match value (the previous behaviour) or Leave unchanged when a value is not found in the lookup. Thanks to Torgrim S. for the suggestion.

Lookup with no match options

5. Double-click on the column header of a dataset in the Right pane to show the most frequent values in that column. Up to 20 values are shown. Values are treated as text. Thanks to Dave V. for the suggestion.

Column value frequency window

6. The Rename transform did not always update correctly if you changed a name more than once in the Right pane. This is now fixed.

7. The Javascript language expects the decimal separator for numbers to be ‘.’ (dot), regardless of your locale. If the decimal separator for the locale set in Preferences is not ‘.’, you are now warned of this the first time you display a Javascript transform in the Right pane. Thanks to Bernard K. for reporting this.

Mac only

8. Previously starting Easy Data Transform by double-clicking on a .transform file didn’t work correctly if open previous file at start-up was checked in Preferences. This is now fixed. Thanks to Adam E. for reporting this.

9. In macOS 10.15 (Catalina), saving a file over an existing file with the same name can cause a crash. This appears to be a macOS bug and we hope Apple will fix it soon. As a workaround you should either:

MacOS 10.14 and earlier are not affected.


Windows Logo Windows Download

v1.10.0 for Windows 10 / 8 / 7 (49 MB)

Apple Logo Mac Download

v1.10.0 for Mac 10.15 to 10.12 (24 MB)

Questions or problems?

Email support@easydatatransform.com