Extract month/year data and populate new column

[Max_Lam]

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!

[Luke_C · Accepted 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:

[mceleavey · Accepted solution]

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.

[Max_Lam]

Thank you both for your help!