O'Reilly logo

QlikView Scripting by Matt Floyd

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using the Transformation Wizard

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.

Removing garbage from data files

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required