This release adds improvements to v1.1.0. 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.
1. Much faster input of CSV files.
2. Improvements to CSV reading to better handle badly formed CSV files.
3. Faster output of CSV files.
4. The Gather transform has been added. Sometimes called ‘pivot longer’ or ‘group by’, this transform allows you to convert multiple columns in a key column and a value column. For example you can transform:
Into:
Using:
5. The Spread transform has been added. Sometimes called ‘pivot wider’ or ‘crosstab’, this transform allows you to convert a pair of columns into multiple columns. For example you can transform:
Into:
Using:
NB/ Spread is the opposite of Gather.
6. The Summary transform has been added. This transform creates a new dataset that is a summary of the values in the input dataset. For each selected column it reports:
Working out which values fit the allowed date formats (specified in the Preferences) can be slow for large datasets. You can turn this off by unchecking check for dates.
7. The Substitution transform has been added. This transform allows you to substitute one or more column values into text. For example you could use it to create SQL statements to insert the values into a database:
8. You can now uncheck simplify whitespace in the Right pane for input items, if you want to preserve carriage returns and tabs while reading in CSV files. Otherwise they will be converted to spaces.
9. You can now uncheck ignore empty rows in the Right pane for input items, if you want to preserve empty rows while reading in CSV files.
10. You can now uncheck Byte Order Mark in the Right pane for output items, if you don’t want to write a BOM to UTF encoded output files.
11. Added an Export data button in the Right pane for input items.
12. When outputting XML, spaces in column header names are now replaced by ‘-‘ (dash) characters to ensure that the XML produced is valid. The comment has also been moved after the <?xml ..?> line to better conform to the XML specification.
13. The user interface font size is now a better size on high resolution displays.
v1.2.0 for Windows 10 / 8 / 7 (22 MB)
v1.2.0 for Mac 10.15 to 10.12 (21 MB)
Questions or problems?