For in depth information regarding the use of shaping operations within Paxata, click the links below:
The Deduplicate function searches your data for rows that match each other exactly, and condenses them into a single row, removing duplicate entries from your data.
This function allows for the user to utilize a number of different aggregate functions (listed below) on any of the existing columns within the dataset.
Transpose is the simplest of the Shape functions, essentially allowing you to switch your rows and columns (imagine rotating your data 90 degrees).
Pivot is similar to transpose in that it allows you to rearrange your column headers into row headers; but, it also allows you to perform aggregate functions on selected columns to be displayed as the body of data within your pivot table.
The Depivot function is a very powerful function that allows you to take your data and stack columns into two columns (one column containing the Column headers that the original data came from, a second column containing the value from that column).