Easy Data Transform newsletter
21-Dec-2023

Easy Data Transform v1.46.0 released

Easy Data Transform v1.46.0 is now available for Windows and Mac. This release adds lots of improvements to Easy Data Transform v1.45.0, including:

• A new Correlate transform.

• A new opening a .transform with auto run setting in Preferences.

• Optionally set a header name for the new column created in:
  • Calculate
  • Compare Cols
  • Concat Cols
  • Count
  • Interpolate
  • Lookup
  • Moving
  • Total

• The New Rows transform now has additional For option values.

• The Calculate transform now has additional operations:

  • IndexOf
  • LastIndexOf
  • Quarter
  • JulianDayToDate

• You can now paste new header names to and from the clipboard in the Right pane of the Rename Cols transform.

• You can now copy the contents of the Right pane Characters tab to the clipboard.

• The right click menu for the data table now has the additional option Copy Selected Header Only.

• Previously the Num Base transform guessed the base of each value separately when Base From was set to Guess. It now guesses the base on a column by column basis, looking at the values in the first 25 rows of each column.

• When you select a Note item in the Center pane you can now start typing into the comment field in the Right pane without having to click on the comment field first.

• You can now display a value from the Right pane data table in the Value window.

• For transforms that support drilldown, the drilldown value can now be accessed by selecting Drilldown… from the right click menu.

• Count now tries to preserve the case of the original values if case sensitive is not checked.

• Bug fixes.

Find out more and download the new release from the release page:

Download the update

This is a free upgrade for everyone with a valid v1 license. If you purchased a v1 license you can have it resent here.

If you don’t have a v1 license you can purchase one here.

Thanks to everyone who sent us bug reports and suggestions for improvements. Please let us know if you have any problems with the new release.

New video

We recently added a new videos to the Easy Data Transform Youtube channel:

How to calculate Pearson product moment correlation coefficients

There are now 47 videos on the Easy Data Transform Youtube channel.

Likes and subscribes help us with the YouTube algorithm and are much appreciated.

In the forum

Recent posts in the forum that might be of interest include:

• GCHQ Xmas Challenge
• Correlation and Random
• Adventofcode.com
• The new Calculate indexOf() and lastIndexOf() operations()
• What are the top five reasons you use EDT?
• Weird Request - Every nth Row - Split to Columns
• Scramble data in an Excel column

Article

Some Easy Data Transform users might find this of interest:

• 6 months as a Data Science freelance - some tips

Seasons greetings

We wish all our customers a happy festive season. We will still be checking the forum and emails over the festive period, except on Christmas day.

Expect the Easy Data Transform release schedule to slow down for some months in 2024, as we start on Easy Data Transform v2. Lots of new features and improvements are planned!

And finally…

From the marvellous XKCD:

Andy Brice
Oryx Digital Ltd
21-Dec-2023