Transform

The Transform category includes tools that summarize or rearrange data.

Arrange Tool: The Arrange tool manually transposes and rearranges your data fields for presentation purposes. Data is transformed so that each record is turned into multiple records and columns can be created by using field description data.

Count Records Tool: The Count Records tool returns a count of how many records are going through the tool.

Cross Tab Tool: The Cross Tab tool pivots the orientation of the data table and transforms the data so vertical data fields can be viewed on a horizontal axis, summarizing data where specified.

Running Total Tool: The Running Total tool calculates a cumulative sum, per record, in a file.

Summarize Tool: The Summarize tool can conduct a host of summary processes, including: grouping, summing, count, spatial object processing, string concatenation, and much more.

Transpose Tool: The Transpose tool pivots the orientation of the data table and transforms the data so you can view horizontal data fields on a vertical axis.

Weighted Average Tool: The Weighted Average tool calculates the weighted average of an incoming data field. A weighted average is similar to a common average, but instead of all records contributing equally to the average, the concept of weight means some records contribute more than others.