The Transformation Wizard can be accessed from the Script Editor, when you are connecting to a flat file such as a table file. Once you have selected the file, click on the Enable Transformation Step button to start the Transformation Wizard.
Let's start using the Transformation Wizard by opening a
.xls file and removing some of the garbage (unnecessary) rows and columns from the data. This example uses a spreadsheet available from Packt Publishing, located in the Downloads section for this book title. Visit the Packt Publishing website and download the
Hospital_General_Information_Chap3.xls spreadsheet (this data is adapted from multiple healthcare and hospital spread sheets publicly ...