Introduction

PhixFlow has exceptionally powerful data transformation capabilities that allow it to handle even the most complex of data manipulations. Below are the key areas that cover how you can use PhixFlow to transform your data. 

Pages in this topic

• Understanding Tables and Pipes
  • Types of Table and When to Use Them
  • Merging Tables
  • Combining Data (Union)
  • Splitting Records
  • Aggregating Data
  • Using Directed Pipes to Read from Large Data Sets
• Enriching Data
  • Enriching Data with Data From Another Set
  • Match and Deduplicate Data
  • Superseding
  • Generating Counts and Other Statistics
  • Grouping and Referencing Data Using Calculate-By-Set
  • Configuring User File Uploads

Additional topics

• Filtering and Sorting Data
• Expressions and PhixScripts

Reference Information

• Analysis Model Window and Toolbars
• Analysis Model Properties
• Table properties
• Attribute properties 
• Pipe properties 
• Sort Order properties