Table of Contents
Category: Transform / Advanced
This action obtains various metadata of the current dataset.
Obtaining column names can be helpful in many cases:
Table metadata can be used to obtain the total number of rows or a list of column names in a table.
For data that appears numeric in nature (zip codes, phone numbers, ID numbers, etc.), this action can identify whether the data is being captured as numeric or text.
This action can help determine if numeric data in a given column is falling within an expected range (min and max values).
|The name of the dataset.
|Total number of columns
|The number of columns in the dataset.
|Total number of rows
|The number of rows in the dataset.
|The names of all of the columns in the dataset.
|The count of distinct values in the column.
|Whether all values in the column are unique. Returns TRUE or FALSE.
|The count of empty cells in the columns.
|The count of errors appearing in the column.
|The number of text-based values in the column.
|The number of numeric values in the column.
|The number of integers in the column. (Numeric columns only.)
|The number of floating-point numeric values in the column. (Numeric columns only.)
|The smallest numeric value in the column. (Numeric columns only.)
|The largest numeric value in the column. (Numeric columns only.)
|Min text length
|The length in characters of the shortest text value in the column. (Text columns only.)
|Max text length
|The length in characters of the longest text value in the column. (Text columns only.)
|If the column has been renamed, what the original name was.
|The defined format of the numeric data in the column. (Numeric columns only.)
|Annotations for the column.
When selecting column-based metadata items, it is helpful to ensure the "Column names" items has been selected to confirm what column the metadata results area associated with.
The metadata generated by this action is based on the structure of the dataset at the point this action is inserted in the action chain. If the raw file's structure has been changed (columns removed or renamed, rows trimmed, etc.) those are the values that will appear.
The "Original name" column item will display the original starting name of the column, regardless of how many times it may have been renamed throughout the workflow. (e.g., it does not show the last name it may have had)