Data preparation is an essential task whenever raw data is to be transformed to a usable form. The end use could be data analysis, report generation, or SQL query. In three articles we are exploring preparing raw data, stored in MySQL database, for an Excel report using Toad Data Point. In the first article we created a data source by adding raw data to a MySQL table. The data has several issues that need to be fixed, including erroneous data, missing data, null values, inappropriate data types, extra spaces, and duplicate data. We profiled the data to find all the issues, with the data displayed in a histogram. We identified the issues that need to be fixed by profiling the data. In this continuation article we shall extract data from the database and transform the data to a usable form.
This is a companion discussion topic for the original entry at https://blog.toadworld.com/data-preparation-using-toad-data-point-2