Date part
Extract specific date information from a date column.
Extract specific date information from a date column. You can select any of the following values:
Year
Month
Quarter
Week
Day
Weekday
Hour
Minute
Second
You can also opt to select all values or none of the values in the configuration.
When to use this tool
Use when your data set contains a general date column, and you want to break it down further.
Input
The Date part tool requires one data input.
Configuration
Use the following configuration options to help create your Date part configuration.
In Pipe builder, add your data source.
Click +Add Tool.
Click See all tools.
In the search bar, search for Date part. Click Add tool.
Tip
You can also find the Date part tool in the Clean section.
Connect the tool to your data set.
In the configuration pane, enter the following information:
Table 47. Date part tool configurationField
Description
Target column
Select the target column.
Date Parts
Select the date parts to extract specific date information.