Both sides previous revisionPrevious revisionNext revision | Previous revision |
transformations:makedatetimecolumns [2021/04/23 18:17] – craigt | transformations:makedatetimecolumns [2021/07/19 02:24] (current) – [Examples] 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.) |
| |
| |
| |
| |
\\ | \\ |
=====Examples===== | =====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:** | **Source table:** |
> Select options "Year-quarter", "Week day" (output "English"), and "ISO week number". | > Select options "Year-quarter", "Week day" (output "English"), and "ISO week number". |
\\ | \\ |
**Result:** | **Result table:** |
^ Date ^ Year-quarter ^ Week day ^ ISO Week number ^ | ^ Date ^ Year-quarter ^ Week day ^ ISO Week number ^ |
| 2020-Nov-28 | 2020-Q4 | Sat | 48| | | 2020-Nov-28 | 2020-Q4 | Sat | 48| |
| 2020-Nov-29 | 2020-Q4 | Sun | 48| | | 2020-Nov-29 | 2020-Q4 | Sun | 48| |
| 2020-Nov-30 | 2020-Q4 | Mon | 49| | | 2020-Nov-30 | 2020-Q4 | Mon | 49| |
| |
| \\ |
| ====Community examples==== |
| * [[https://community.easymorph.com/t//1587/7|How to format the duration in more than 24h]] ([[https://community.easymorph.com/uploads/short-url/w6CnxwiidYjcJHNRrmUIXI74NC2.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Table 1//; Action position: //5//) |
| * [[https://community.easymorph.com/t//2297/2|Excel: Import Date Headings as number]] ([[https://community.easymorph.com/uploads/short-url/ppgiXxeiQbK0O3owwca3pxAsOyH.morph|Project]]; Module: //Main//; Group: //Group 1//; Table: //New header//; Action position: //4//) |
| |
\\ | \\ |