I have individual columns for day, month and year and I want to create a Date Column by combining these three columns. Below is an image of data that I want to process.
top of page
Forum
Ignite Discussions : Ask Questions, Find Answers, Share Expertise about Sparkflows
Edited: May 29, 2023
How to merge Day Column, Month Column and Year Column into a single column known as Date?
How to merge Day Column, Month Column and Year Column into a single column known as Date?
1 comment
Comments (1)
bottom of page
Hi Ragita, hope you are doing fine. Please find the solution below:
Below is the image of workflow:
Follow the below steps to get the required result:
1. Load the input data using the read processor.
2. Use Concat Column processor to concatenate year, month and day columns into a single column known as DATE. To do so, select year, month, day columns and set the concatenated column name as DATE and separator as dash/hyphen.
3. After setting the configuration, attach string to date processor to cast string into date format by specifying the columns: input column format, output column names and new data type as given in image below:
4. Add Print N Rows processor to print the final output.