Page tree

 

Support | BlogContact Us | 844.332.2821

 

Contents:

This documentation applies to Trifacta Wrangler. Download this free product.
Registered users of this product or Trifacta Wrangler Enterprise should login to Product Docs through the application.

Derives the numeric value for the day of the week (1, 2, etc.). Input must be a reference to a column containing Datetime values.

NOTE: If the source Datetime value does not include a valid input for this function, a missing value is returned.

Tip: You can use the DATEFORMAT function to generate text versions of the day of the week. See Examples below.

Basic Usage

Column reference example:

derive value:WEEKDAY(MyDate)

Output: Generates a column of values containing the numeric weekday values derived from the MyDate column.

Syntax

derive value:WEEKDAY(datetime_col)

ArgumentRequired?Data TypeDescription
datetime_colYdatetimeName of column whose weekday values are to be computed

For more information on syntax standards, see Language Documentation Syntax Notes.

datetime_col

Name of the column whose day-of-week value is to be computed.

  • Missing values for this function in the source data result in missing values in the output.
  • Multiple columns and wildcards are not supported.

Tip: You cannot insert constant Datetime values as inputs to this function. However, you can use the following: WEEKDAY(DATE(12,20,2017)).

Usage Notes:

Required?Data TypeExample Value
YesDatetimemyDate

Examples

Example - Date of week functions

This example illustrates how you can apply functions to derive day-of-week values out of a column of Datetime type:

  • WEEKDAY - returns numeric value for the day of the week for source Datetime values. See WEEKDAY Function
  • DATEFORMAT - can be used to format Datetime values in many different ways. See DATEFORMAT Function.

Source:

myDate
10/30/17
10/31/17
11/1/17
11/2/17
11/3/17
11/4/17
11/5/17
11/6/17


Transform:

The following generates a numeric value for the day of week in a new column:

derive value: WEEKDAY (myDate) as:'weekNum'

The following generates a full text version of the name of the day of the week:

derive value:DATEFORMAT(myDate, 'EEEE') as:'weekNameFull'

The following generates a three-letter abbreviation for the name of the day of the week:

derive value:DATEFORMAT(myDate, 'EEE') as:'weekNameShort'

 

Results:

myDateweekNumweekNameFullweekNameShort
10/30/171MondayMon
10/31/172TuesdayTue
11/1/173WednesdayWed
11/2/174ThursdayThu
11/3/175FridayFri
11/4/176SaturdaySat
11/5/177SundaySun
11/6/171MondayMon

Your Rating: Results: PatheticBadOKGoodOutstanding! 17 rates

This page has no comments.