Easy Data Transform v2.3.0
For Windows and Mac

This release adds enhancements and bug fixes to Easy Data Transform v2.2.0.

You will require a v2 license to use this release after the free trial has expired. You can buy a new license key here or, if you have a v1 license key, you can buy a discounted upgrade here. See also our upgrade FAQ.

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.

The download links are at the bottom of the page.

System requirements

Windows: 64 bit Windows 11/10/8/7 (Intel processor) or 64 bit Windows 11 (ARM processor).
Mac: macOS 15.x to 10.13 (Universal Binary for Intel or ARM M series processors).

Compatibility

This version can read .transform files saved in all previous versions.

Windows and Mac

1. When a transform acts on multiple columns, you can now check or uncheck columns that match various criteria. For example, you can check all columns containing ‘provider’:

Or uncheck all columns where every value contains just ‘0’ characters or is empty, using a regular expression:

Click Apply to make the changes shown in the preview.

The column matching criteria are:

• Column name contains
• Column name doesn’t contain
• Column name matches regex
• Column name doesn’t match regex
• All values are equal to
• Any value is equal to
• No values are equal to
• All values match regex
• Any value matches regex
• No values match regex
• All values are empty
• Any value is empty
• No values are empty

2. You can now filter by column name in the Right pane when a Rename Cols transform is selected. Any columns whose old or new names do not contain the filter text are temporarily hidden. The filtering is sensitive to whitespace, but not case.

Thanks to @Prashant for the suggestion.

3. You can now filter by column name in the Right pane when a Unique transform is selected. Any columns whose names do not contain the filter text are temporarily hidden. The filtering is sensitive to whitespace, but not case. Hidden columns are unselected.

4. You can now filter by column in the Right pane when a Verify transform is selected. Any columns whose names do not contain the filter text are temporarily hidden. The filtering is sensitive to whitespace, but not case.

5. For the Unique transform, the Set button has been changed to Apply and moved to the right. We feel this is more intuitive.

6. Previously a warning window appeared if you tried to write more rows or columns to Excel than Excel supports. Now the same message is also written to the Warnings tab of the output item.