Date and string conversion

1. Overview

1.1 Expected effect

Sometimes, you need to convert the "Text" or "Value" field to the "Date" field type, for example, convert the numerical "1621221876057" field to the standard "Date" field, as shown in the following figure:

1.2 Implementation ideas

Use the self-service dataset "Add column" and implement it through "formula/function".

Note: This paper lists some common conversion methods, which will be supplemented according to the actual data structure.

2. Operation steps

2.1 Add columns in self-service dataset

Add a self-service dataset, select the numerical field under the corresponding dataset (this file takes the fixed data value 1621221876057 as an example), click "+" to add a new column, as shown in the following figure:

Note: the functions and fields in the formula box need to be selected by clicking the selection area on the left, and cannot be entered manually.

2.2 View the effects

See more details in section 1.2.

3. Other conversion examples