Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | Last revisionBoth sides next revision |
transformations:makedatetimecolumns [2021/07/15 12:27] – [Examples] craigt | transformations:makedatetimecolumns [2021/07/15 12:28] – craigt |
---|
* __The Column Profile/Filter window:__ In the //Values// tab, you will see date/time values leading with the date serial number (e.g., 32888 15-Jan-1990), while text-based values will only show the value (e.g., 15-Jan-1990). In the //Metadata// tab, the number format for date/times will be "dd-MMM-yyyy" while text values will not have a number format. | * __The Column Profile/Filter window:__ In the //Values// tab, you will see date/time values leading with the date serial number (e.g., 32888 15-Jan-1990), while text-based values will only show the value (e.g., 15-Jan-1990). In the //Metadata// tab, the number format for date/times will be "dd-MMM-yyyy" while text values will not have a number format. |
* __Analysis View, Table metadata:__ Date/time column values will show counts under "numbers" and "integers" while text-based values will show counts under "text". (These same results will appear using the //Table metadata// action.) | * __Analysis View, Table metadata:__ Date/time column values will show counts under "numbers" and "integers" while text-based values will show counts under "text". (These same results will appear using the //Table metadata// action.) |
| |
| |
| |
| |
\\ | \\ |