PAW - Process & Analytics Workbench

Transform The Way You Work With Data. Massage - Integrate - Automate

14-Day Free Trial
Buy Now

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

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