Hi, I am new in Alteryx and would need some help to do the following:
From the excel file, the first row would contain the month and year which I need to extract.
I need to add a new column to the existing dataset and populate the whole column with that specific month/year data.
I was able to extract the string of the month/year data using Regex but I could not find a way to populate the new column with the extracted string.
Thank you in advance!
Solved! Go to Solution.
Hi @Max_Lam
Extracting that info is the hard part, now you can just use an append fields tool to have that data repeat for each row in the dataset. Here's a very simple example:
Hi @Max_Lam ,
I've extracted the Month and Year and used the Append tool to create the new columns.
Workflow attached, I hope this helps.
M.
Thank you both for your help!