Easy Data Transform v2.1.0
For Windows and Mac

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

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. The Calculate transform has additional functions:

• MSecsToTime converts an integer number of milliseconds since midnight to a 24 hour time. Milliseconds are omitted if there are 0 milliseconds.

• TimeToMSecs converts a 24 hour time into the number of milliseconds since midnight. Minutes and milliseconds are optional.

You can use these functions, together with transforms such as Total, to perform arithmetic with times.

If you want values > 86400000 to wrap around to less than 24 hours, then use the Calculate to % Modulus by 86400000 before MSecsToTime.

2. We have improved how Easy Data Transform handles real (floating point) numbers, to try to avoid numerical artifacts.

Note that these artifacts can still occur in some cases. This is due to how floating point arithmetic works. Fractional values whose denominator is not a power of 2 (such as 0.1 = 1/10), cannot be exactly represented as floating point numbers of finite precision. It is not a bug in Easy Data Transform.

For a more in-depth explanation, see what Every Programmer Should Know About Floating-Point Arithmetic.

Thanks to Giorgio LS for raising this issue.

3. Batch processing now shows some additional summary information.

Thanks to @Olaf for suggesting this.

The overwrite warning message is also now only shown for files that are overwritten more than once.

The automatic sizing of the columns has also been improved.

4. The No match value option in the Lookup transform can now be a column variable.

5. When a .transform file with Run>Auto Run disabled was loaded, column related parameters were shown as Columns: 0 column(s) until initialised, which could be confusing. They are now shown with tooltip Columns: Needs updating. Thanks for Tracy P. for reporting this.

6. Some column drop-downs were incorrectly shown with a red border if the first column was selected. This is now fixed.

Mac only

7. Cmd+M now minimizes the main window. The View>Magnify Cursor shortcut has been changed from Cmd+M to Option+M to avoid overriding the window minimize shortcut. Thanks to @FGHJ for reporting the issue.