instal the new version for iphoneEasy Data Transform

Instal the new version for iphoneEasy Data Transform download#
Instal the new version for iphoneEasy Data Transform windows#

The Average length row in the Summary transform output has been renamed to Average length ex empty and a new Average length inc empty row has been added. A similar change has been made to the Column Values window.ġ3. The Min length row in the Summary transform output has been renamed to Min length ex empty and a new Min length inc empty row has been added. Leading and trailing whitespace is now ignored when inferring whether a column is of type boolean, date or time from values (this was already done for numeric).ġ2. Now a column is inferred as numeric if it contains at least 1 number and all non-numeric values are empty or NaN.ġ1. Previously a column was inferred as numeric if it contained at least 1 number and all non-numeric values were empty. Previously some invalid numeric operations returned nan and some returned NaN. These now return NaN (not a number) instead.ĩ. Previously some operations resulting in numerical overflow, for example using a Calculate transform to raise 100 to the power 100, could return inf (infinity). Thanks to Rafal for reporting the issue.Ĩ.

It now dynamically re-positions itself as you type. Previously the pop-up transform menu that appears as you type, was sometimes strangely positioned. In Run>Auto run mode previously it was possible to crash Easy Data Transform while dragging columns to a different order in the Right pane of the Reorder Cols transform. Fixed an issue in the Javascript and Substitute transforms where $(n) could be replaced with the value of the nth column rather than a column named n.Ħ. This helps with seeing which items are connected.ĥ. When you hover over an item in the Center pane, the item and any connections are now subtly highlighted. You can now click the Unique icon in the Right pane of the Rename Cols transform to make every header name unique. Check ignore if already added to ignore names where the text has already been added. You can now click the Prefix/Suffix icon in the Right pane of the Rename Cols transform to add text to the front or back of all existing header names. We may add exponential and weighted moving averages in future, if there is enough interest.Ģ. Or you can calculate a 3 day sum using the current row and the rows above and below, if available: For example, you can calculate the moving average of a sales column over 7 days, leaving the first 6 days empty: This allows you to calculate a moving average/median/sum/minimum/maximum over a specified interval. You can uninstall old releases after you have successfully installed this version. Please let us know of any problems or issues you encounter with the release.

We recommend that you back-up important transform files before installing any new release.

Instal the new version for iphoneEasy Data Transform download#

The download link is at the bottom of the page.

Instal the new version for iphoneEasy Data Transform windows#

This release adds improvements and bug fixes to v1.38.2 on Windows and Mac.