PAW - Process & Analytics Workbench

PAW Support

Step-by-step Tutorials

1. 1. Merging data - Learn how to import data from an Excel file and a MySQL database and merge data in PAW
2. 2. Loading data to a database - Learn how to import data from multiple sources, create tables and manage data, summarize data, and finally load data into an external database.

Reference Material

Concepts and User Interface The PAW UI Usage Lifecycle Processes and Steps Manual Datasets Tasks Customizable Inputs Importing and Exporting Data Database Query Import from Excel Import from web pages Importing text files Exporting to Excel and CSV formats

Data Processing Filtering Summarizing Match/merge and joining data Calculated fields Getting distinct values Parsing text Parsing XML Storing data to local datasets Advanced Scripting Working with dates Handling text strings Loading data into databases Invoking web services Integrating with Microsoft Office Tranferring files

Data Management Solution User Guide (1 MB)

Desktop Installation

Learn how easy it is to install PAW on your desktop, step by step.