transformations:metadata
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
transformations:metadata [2018/05/23 23:06] – dmitry | transformations:metadata [2021/04/21 15:13] (current) – craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Table metadata | + | {{ transformations: |
+ | ====== | ||
+ | Category: Transform / Advanced\\ | ||
- | This action obtains various metadata of the current dataset, namely: | + | \\ |
+ | =====Description===== | ||
+ | This action obtains various metadata of the current dataset.\\ | ||
- | * Total number of columns | + | \\ |
- | * Total number of rows | + | =====Use cases===== |
- | * Column | + | Obtaining column |
- | ===Use cases=== | + | Together with [[transformations: |
- | 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 // | ||
+ | |||
+ | This action can help determine if numeric data in a given column is falling within an expected range (min and max values).\\ | ||
+ | |||
+ | |||
+ | \\ | ||
+ | =====Action settings===== | ||
+ | ====Table metadata==== | ||
+ | ^Metadata item^Description^ | ||
+ | |Table name |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.| | ||
+ | \\ | ||
+ | ====Column metadata==== | ||
+ | ^Metadata item^Description^ | ||
+ | |Column names |The names of all of the columns in the dataset.| | ||
+ | |Distinct count |The count of distinct values in the column.| | ||
+ | |All unique | ||
+ | |Empty count |The count of empty cells in the columns.| | ||
+ | |Error count |The count of errors appearing in the column.| | ||
+ | |Text count |The number of text-based values in the column.| | ||
+ | |Number count |The number of numeric values in the column.| | ||
+ | |Integer count |The number of integers in the column. (Numeric columns only.)| | ||
+ | |Non-integer count |The number of floating-point numeric values in the column. (Numeric columns only.)| | ||
+ | |Min number | ||
+ | |Max number | ||
+ | |Min text length | ||
+ | |Max text length | ||
+ | |Original name |If the column has been renamed, what the original name was.| | ||
+ | |Number format | ||
+ | |Annotation | ||
+ | |||
+ | \\ | ||
+ | =====Remarks===== | ||
+ | When selecting column-based metadata items, it is helpful to ensure the " | ||
+ | |||
+ | 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. | ||
+ | |||
+ | The " | ||
+ | |||
+ | \\ | ||
+ | =====See also===== | ||
+ | * [[transformations: | ||
+ | * [[syntax: | ||
- | It can also be used to obtain the total number of rows, or a list of column names in a table. |
transformations/metadata.1527131215.txt.gz · Last modified: 2018/05/23 23:06 by dmitry