I released v1.1.0 of Easy Data Transform this week. It is a big upgrade, with some major new features.
There is a new Lookup transform. This allows you to lookup values for one dataset in another dataset. For example, if you have a dataset with a column for country code and another dataset with columns for the country code and tax rate, you can look up the tax rate by country code.
Previously you could only output your data in Excel and delimited text formats (including CSV and TSV). The new release also adds output to JSON, HTML, Markdown, vCard, YAML and XML formats.
I have improved the speed of the Join transform significantly using hashing. This makes a big difference with large datasets.
To save time, Easy Data Transform guesses the likely columns you want to use as keys when you Join, Intersect, Lookup or Subtract two datasets. For example if 2 datasets both have colummns called ‘ID’ with lots of unique values that are common to both columns, it will choose those two columns as the default key columns. I have improved the heuristic used to set the default columns.
You can now add comments to input, transform and output nodes as a note to a colleague or your future self.
You can now snap your input, transform and output nodes to a grid, so you can keep your layout all lovely and neat.
I have also made some bug fixes and minor improvements.
Haven’t tried Easy Data Transform yet? Got some table or list data that you need to wrangle into a more useful form? Take the free trial for a spin.