Extract Date Component
Description
This activity extracts specific date components from the given columns. Users can define which parts of the date should be extracted into new columns.
Input
Data
Output
Transformed Data
Configuration Fields
- Date column Column containing the date value.
- Start Day Of Week First day of the week.
- Components Components to extract from the date into a new column (e.g., Year, Month, Day, etc.).
- Prefix Optional prefix for the new column.
- Include original If enabled, keeps the input columns along with the extracted column. If disabled, only the extracted column is included in the output.
Sample Input
| ID | Date |
|---|---|
| 1 | 2023-09-15 |
| 2 | 2022-05-20 |
| 3 | 2021-12-30 |
Sample Configuration
Sample Output
| ID | Date | Transact_Year | Transact_Month | Transact_Day |
|---|---|---|---|---|
| 1 | 2023-09-15 | 2023 | 09 | 15 |
| 2 | 2022-05-20 | 2022 | 05 | 20 |
| 3 | 2021-12-30 | 2021 | 12 | 30 |