You are here:

Field Info Tool

The Field Info tool allows the user to see in tabular form, the name of fields within a data stream as well as the field order, field type and field size. A typical use scenario is to combine with the Test tool (and maybe Block Until Done tool) to validate a schema is correct before doing scheduled processing.

This is one of the few tools that will output records even if there are no records coming in to it.

The Output of this tool is almost identical to the Output Properties, viewable from any tool's Properties:

Example: The following is a sample output of the Field Info Tool

Name	Type	Size	Scale	Source	Description
LOCATION	String	45	[Null ]	File...\SampleData\Sample.csv
SIZE	Double	8	[Null]	File...\SampleData\Sample.csv
VALUE	Int32	4	[Null]	File...\SampleData\Sample.csv
REVENUE	FixedDecimal	6	2	Formula:TONUMBER([REVENUE])
ADULTCY	Int32	4	[Null]	Allocate: Software\Alteryx\Portfolio\6.30\Alteryx_US_AGS_07A	Basic Variables Current Year Estimates (2007) Adult Population
SPATIALOBJECT	SpatialObj	536870911	[Null]	Geocoder: PortfolioExplorer_Tele Atlas Q3 2007 US

Name: Field names within the data stream

Type: Type of Data Field

Size: Length of the data field

Scale:With respect to Fixed Decimal data types , scale refers to the digits of precision.

Source: Contains the tool or the file the field came from. May also contain additional Metainfo such as a specific dataset from a plugin. The tools that report metainfo would be Allocate Input and Allocate Append, CASS, Geocoder, and tools that utilize calculate drivetime such as Trade Area, Distance, Find Nearest.

Description: May or may not contain information. If data is appended from Allocate for example, the descriptive longer field name will be contained here. Additionally the user can add their own field description via the Select tool and this information will stay associated with the field.

While this tool has no configuration properties, a user will need to link up a Browse tool or an Output Data tool to utilize the functionality of this tool.