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 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: