2 new transforms

News
1

2 new transforms are available in the latest snapshot release:

The Units transform for converting between different angle, area, energy, length, mass, power, pressure, temperature, time, velocity and volume units.

units-example
units-example700×1013 144 KB

The Decode transform for converting to/from Base64, URL or HTML encoding.

Previously only JSON files of < 128 MB could be read. That resitriction has now been removed. Although you might still run out of memory for very large JSON files. Especially deeply nested JSON which is much less compact when converted to a table.

The Windows version of Easy Data Transform now only runs on 64 bit versions of Windows. In the unlikely event that you have an old 32 bit version of Windows, you can continue to run Easy Data Transform v1.12.1.

The downloads are:

Windows: https://www.easydatatransform.com/downloads/EasyDataTransform_1_12_2_snapshot_3.exe

Mac: https://www.easydatatransform.com/downloads/EasyDataTransform_1_12_2_snapshot_3.dmg

This is in addition to the changes in the previous snapshot.

This release uses a new version of a third party library (Qt). Please let us know if this causes any issues.

3 Likes
2

Definitely an improvement when handling larger files. I’m now able to transform the smallest of the three large files I’m dealing with, both on MacOS and Win10. The two largest ones are admittedly outliers, so I’m pretty happy with this release, thanks!

Filesizes

1 Like
3

@ppival
Thanks for letting me know.

4

Decode just saved me about 40 transforms on a sheet and it recalculates (over a million records) in about a third the time. Super update!

1 Like
5

That is good to hear. What are you encoding from/to?

The UI/options likely to be tweaked a bit, so you might have to reset the settings when you move the .transform to the next release.

6

The snapshots have now been superceded by v1.13.0:
https://www.easydatatransform.com/easydatatransform_v1d0.html

7

The main application is cleaning and prepping streaming server log files for downstream usage in database and visualization software. From URL encoding especially helps in two cases where the field data is not usable in its native form.

I just tried 1.13.0 and it’s working fine with a minor selection in the right side panel.

I can see EDT as a useful/essential tool for anyone in the analytics trade who need to clean and prep data routinely.

1 Like