PAW helps you with data massaging and data integration tasks, enabling you to build custom reports and perform adhoc data analysis. You can import data from Excel, CSV, XML, text files, databases, and web pages. You can join and compare datasets, convert and map fields, find distinct values, consolidate and summarize with drill-down capability, and perform lots of other manipulations. As you work with your data, you see the changes and while doing this, you end up building a repeatable proces that can be run automatically. PAW is focused on power business users and technology professionals. It enables you to get the job done quicker, with fewer hand-offs and context switches.
What's new in this version:
Version 1.5.2 provides a new simpler look and feel, drill-down capability.