What is the Transform and Cleanse in Toad?
The Transformation and Cleanse tool allows you to manipulate and change data from a table, a data grid, or a SQL query. Transform and Cleanse leaves the source table intact. A sampling of data, 1000 rows or less, displays in the window.
After transforming data, you can export the data as an Excel or .csv file, save it to Local Storage, publish it to Intelligence Central, or send it to Automation. You can also save your work as a Transform and Cleanse document (.tct).
In Toad Data Point 3.7 we've rewritten the transformation and cleanse window. This new window now includes data profiling information, many more transformation rules, and a robust engine for processing larger amounts of data. The transformation and cleanse utility is acceptable from a right click menu from the Object Explorer, or from the Tools menu where you can enter your own SQL statement to generate the initial data sets, or from a right click from any Query Builder or SQL editor results grid.
Here are 3 videos to get started with Transform and Cleanse:
Video 1: How to access and process data using the Toad Data Point transformation and cleanse utility
