Same as KM, I likely underuse it, but it makes it easy to whip up automations that let me gain already a lot of time and efficiency.Īgain I am not affiliated and receiving no benefit from Easy Data Transform, just loving the software. Yes, it is fun and you always learn something in writing up your code, but it takes time and errors, while with an existing software it can be very efficiently done (and easily reused). I am using it even for simpler conversions from the clipboard, for instance when receiving messed up lists of e-mails to clear out and sort.Īt the end, it all depends on how much you value your time. I think that this kind of software addresses a specific need and it does it elegantly and very well. It is great to have developers so dedicated in continuously improving their software and supporting the users. I had initially some difficulties with the transforms and the developer has been very quick to respond with advice and updating the software to incorporate suggestion on functions and usability from the users. With EDT you have a graphic view of your transforms, you can easily insert other transforms in the connecting nodes, stem out, check the effect of the transform, have alerts for data incongruence, add notes and modify your transforms to adapt to data source changes. I have to say that it is the app that I have been useing the most of the bundle and definitely the one that I recommend to colleagues who need to do any data crunching.Īs my specialty is medicine, and even if could potentially implement javascript routines to possibly get to the result offered by EDT, it is definitely going to take me way more time than an experimented programmer. I bought the software in its first days when it was available as part of a bundle. (It's possible that it may actually be implemented in JavaScript – I notice that for fuller flexibility it allows you to add your own JS code in a 'JavaScript Transform', so perhaps that is the idiom, under the hood, of the other functions/ transforms too).įirst a disclaimer: I am not associated at all with the developer of Easy Data Transform. Merge, dedupe, clean and reformat your data without programming. Using the JXA Automation library on macOS for example, we can write things like: // readFile :: FilePath -> IO StringĪnd // writeFile :: FilePath -> String -> IO ()įor really huge CSV files (several gigabytes), I've found buffered processing through the Python CSV library rather fast and painless, and that too is accessible from within the work-flow of a KM macro.Īnd more generally, as says, all of the data transforms in that package can be written as JavaScript functions. Data transformation software for Windows and Mac. Particular embeddings of JS however, (JXA, Node.js) do provide libraries which define their own file system functions. The ECMAScript standards which define the JS language itself don't cover file access, simply because JS has evolved as a language embedded in contexts like browsers, from which the file system has to be protected. You don't even have to give us your email address.The short answer is yes, though strictly speaking, it depends on what you mean by "JavaScript". I basically just needed to drag and drop the files onto the file area, add the "transformations" and that was it. I had estimated the whole day for the implementation. I've done projects like this a hundred times before. ![]() Just yesterday I had this client with a complex list reorganization: a couple dozen lists with several thousand data sets each, in all forms of CSV - with different delimiters and encodings - and Excel files had to be stacked, deduped, sorted, columns to be merged and removed and new columns to be added in order to create new improved lists. ![]() It has become my go-to tool to prepare both small and massive data sets for both ad-hoc analysis and cleaning data before putting it into a database or BI tool. I have saved hundreds of hours by quickly be able to merge, analyze and unify data. When it comes to quickly prep and unify data sets, even with millions of rows, nothing beats this tool. It's just amazingly quick and intuitive to build up some quite complex transforms. Easy Data Transform is intuitive, fast, and simply does the job. A script that initially took us days to write and test in our existing solution. ![]() It took us less than an hour to transfer a script that filters and merges different datasets to Easy Data Transform. It processed our ~100,000 rows of data in just seconds, where our existing solution needed minutes. We were surprised how fast Easy Data Transform is.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |