Easy Data Transform v1.12.0
For Windows and Mac

This release adds bug fixes and improvements to v1.11.2. 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. You can now Undo and Redo changes using the Edit menu, toolbar buttons or keyboard shortcuts.

Undo/Redo

2. There is now a dual screen mode where the Right pane is moved to a second attached monitor. Select View>Two Screen Mode to activate it. Select it again to merge the Right pane back into the main window. Thanks to Miguel M. and Martin P. for suggesting this.

Dual screen

3. You can now add Note items to the Center pane. These should be useful for documenting complex .transform files. They don’t have connections and don’t perform any data transformations.

Note items

To add a Note item, right click in the Center pane and select Note from the menu. If you right click on an existing item, the Note item will be placed pointing to that item, if there is space. You can change the comment, arrow direction and color of the Note in the Right pane when it is selected. Thanks to various people who suggested this.

Add note item

4. The Right pane now has Data, Warnings, Comment and Results tabs.

Data

Warnings

Comment

Results

5. The following warnings are now shown in the Right pane Warnings tab:

Item Warnings
input file format errors
Date Format transform values that do not match Format from
Interpolate transform non-numeric values and values out of sampling range
Javascript transform Javascript errors and ambiguous column names
Join transform duplicate keys and misses
Lookup transform duplicate keys and misses
Num Format transform non-numeric values
Rename Cols transform duplicate column names
Substitute transform ambiguous column names
output unable to write, format issues


You can show an exclamation mark on items with warnings in the Center pane by checking View>Show Warnings.

Show warnings

6. Warnings are also shown in red in the Center pane tooltips.

Tooltip warnings

7. You can now select File>Open Recent… to display the Open recent window. This allows you to see a list of recently opened .transform files.

Open Recent window

8. You can now choose to output columns to Excel files as formula cells. For example, if you want to export a column of hyperlinks, you can use the Substitute transform to construct the Excel formula =HYPERLINK(“<url>”,”<name>”):

substitute formula

Then output this column with Excel format Formula:

Excel formula format

The Excel file will then contain clickable hyperlinks in that column.

Excel hyperlinks

Note that values that don’t start with = will be exported as text, even if Formula is selected.

9. Previously XML files would not be read in if there were any errors in the XML, such as a missing final brace. Now Easy Data Transform will read in as much as it can and show a warning if it detects there are are any issues. Thanks for Graham R. for the suggestion.

10. The data table now shows context menus if you click on the vertical or horizontal header.

Data context menu

Data context menu

11. Sum numeric, Average numeric, Median numeric, Mode numeric and Stddev numeric rows have been added to the Summary transform. You need to check include statistics for these to appear. Thanks to Dan F. for the suggestion.

12. Median and Mode have been added to the Pivot transform. Thanks to Michael K. for the suggestion.

13. Mode has been added to the Stats transform.

14. The order and names of some option values have been changed for greater consistency between Pivot, Stats and Summary transforms. This could mean that some options need resetting in Stats transforms when .transform files are read from earlier versions.

15. The drawing speed of the right pane has been improved when large numbers of rows are displayed.

16. When you update a Data table in the right pane it will attempt to keep the same horizontal and vertical scroll position. Thanks for Steve M. for the suggestion.

17. The task bar icon now shows progress during processing.

18. Fixed a possible crash in the Stats transform.

Mac only

19. The Center pane font has been changed from Verdana to Helvetica, as some non-latin characters were not rendered correctly in Verdana font.

Downloads

Windows Logo Windows Download

v1.12.0 for Windows 10 / 8 / 7 (50 MB)

Apple Logo Mac Download

v1.12.0 for Mac 11.1 to 10.12 (25 MB)

Questions or problems?

Email support@easydatatransform.com


Do you have a question?
We would love to help.

This pop-up will not be shown again