Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Create a new column with date


I have several files and at the top they will have the date like this but each new file will only be of the same month

file 1-Jan

file 2-feb


I am trying to create a new column for each file that pulls the correct date and drags down because I want to join all the files together but need to identify by date. THANKS!!





I would use a sample tool to get only the first record. You could then append this record to every other record using an append tool.

Alternatively you could use a multi row formula but the formula is just longer and could run into issues if any other records later in the file are populated.