Skip to main content

Transform

Orange polygon containing one grouping of two circles and two triangles followed by another grouping of the same shapes rearranged in a different order.

This tool helps you manually transpose and rearrange your data fields for presentation purposes.

Orange polygon containing a white handheld click counter.

The Count Records tool returns a count of the number of records passing through the tool.

Orange polygon containing a white box with vertically stacked rows followed by an arrow pointing to another box of rows placed in a horizontal row.

The Cross Tab tool moves vertical data fields onto a horizontal axis and summarizes data.

Make Columns ToolMake Columns tool Make Columns Tool

Make Columns tool

The Make Columns tool takes rows of data and arranges them by wrapping records into multiple columns.

Orange polygon containing a stick figure running.

The Running Total tool calculates a cumulative sum on a numeric field per record in a file.

Orange polygon containing white sigma symbol.

The Summarize tool can conduct a host of Summary Processes.

Orange polygon containing a white box of orange rows placed in a horizontal row followed by an arrow pointing to a box with vertically stacked rows.

The Transpose tool allows you to pivot the orientation of the data table.

Orange polygon containing a X with a line over it.

This tool calculates the weighted average of an incoming data field.

In this section: