You are here: Tools > All Tools > Field Info

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.