Differences

This shows you the differences between two versions of the page.

--- transformations:makedatetimecolumns [2021/07/15 12:27] – [Examples] craigt
+++ transformations:makedatetimecolumns [2021/07/19 02:24] (current) – [Examples] craigt
@@ Line 64: / Line 64: @@
   * __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.)
 \\
 =====Examples=====
-**Objective:** Create columns with year-quarter, week day, and ISO week number.\\
+**Example:** Create columns with year-quarter, week day, and ISO week number.\\
 **Source table:**
@@ Line 82: / Line 79: @@
 > Select options "Year-quarter", "Week day" (output "English"), and "ISO week number".
 \\
-**Result:**
+**Result table:**
 ^ Date ^ Year-quarter ^ Week day ^ ISO Week number ^
 | 2020-Nov-28  | 2020-Q4  | Sat  |  48|