Articles in this section

See more

Convert Fields - "convertunix"

Avatar
Tom Sherwood
  • Updated
Follow

Converts a unix timestamp into a human-readable date/date-time format.

Example 1

convertunix_example.png
Example Input 1
dim_A dim_B Date/Time
AAA DDD 1546344000
BBB EEE 1547569800
CCC FFF 1549022400
Example Output 1
dim_A dim_B Date/Time
AAA DDD Jan. 1, 2019, noon
BBB EEE Jan. 15, 2019, 4:30 p.m.
CCC FFF Feb. 1, 2019, noon

 

Example 2

convertunix_example_2.png
Example Input 2
dim_A dim_B Date/Time
AAA DDD 1546344000
BBB EEE 1547569800
CCC FFF 1549022400
Example Output 2
dim_A dim_B Date/Time
AAA DDD Jan. 1, 2019
BBB EEE Jan. 15, 2019
CCC FFF Feb. 1, 2019

 

I Ain't Afraid of No Code!

Example 1 
[
        "convertunix",
        {
            "failonerror": false,
            "subtable": null,
            "as_date": false,
            "fields": [
                "Date/Time"
            ],
            "_comment": null
        }
]
Example 2 
[
        "convertunix",
        {
            "failonerror": false,
            "subtable": null,
            "as_date": true,
            "fields": [
                "Date/Time"
            ],
            "_comment": null
        }
]

param boolean failonerror: Default is false.

param str subtable: Name a subtable in which output will be stored (will create subtable where necessary).

param boolean as_date: If true, removes timestamp element.

param str fields: The column fields to be parsed.

param str comment: A comment that will appear in the Transformation UI.

Related articles

Comments

0 comments

Article is closed for comments.