The product launch includes some new features you've been asking for
50+ data sources
You can now import data from Amazon S3 file storage and from local databases such as, Pervasive SQL, DB2, Exasol, and more. You can also connect to any local database that supports JDBC using the JDBC URL.
Pivot transform
The pivot transform distributes the data for easy consumption. It spreads out the data in long, winding tables by converting categories in rows to columns.
System-wide search powered by Zia
Zia, Zoho's AI assistant for business is now integrated with Zoho DataPrep to perform a global faceted system-wide search of your data.
Advanced Filters
Prepare data using complex data filters based on wildcards, patterns, data quality, regex and more.
Window functions
Window functions enable you to perform summations and calculations based on a rolling window of data, relative to the current row. Unlike normal aggregate functions, the window functions keep the original rows intact and add the result as a new column.