Column Info tool icon

Column Info Tool

Last modified: September 09, 2021

Docs are available before the release of Designer Cloud so you can get a sneak peek. This content might change between now and the official release.

One Tool Example

Field Info has a One Tool Example. Visit Sample Workflows to learn how to access this and many other examples directly in Alteryx Designer Cloud.

Use Column Info to return metadata about each column from the incoming data stream. When paired with the Test tool and Block Until Done tool, the Column Info tool can validate a correct schema before scheduled processing runs.

You don't need to configure this tool.

The output of this tool resembles the metadata tab of the Results window. For each column of input data, this information is returned:

  • Name: The name of the column.
  • Type: The data type of the column.
  • Size: The size of the largest data item within the column.
  • Scale: The digits of precision following the decimal. Only valid with fixed decimal data types.
  • Source: The source tool or file the column came from. The source might also contain additional information when the source is a particular dataset, like Allocate, CASS, Geocoder, or a tool that uses drivetime calculations.
  • Description: Information associated with the column. The description might not contain information unless you add column descriptions or if the data is from a dataset that contains associated descriptions, such as Allocate.

The tool outputs all those columns, even if there are no rows in the incoming data stream.

Was This Page Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support. Can't submit this form? Email us.