Extract month/year data and populate new column

Question

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!

particulars of first registered vehicle_january 2019_r.xlsx

Luke_C · Accepted Answer

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:

mceleavey · Accepted Answer

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.