community
cancel
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

Asteroid

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

etc

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!!

 

 

 

Capture11111.PNG

Quasar
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.
Labels