Create a new column with date

[chughes49]

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

[PhilipMannering]

How are you bringing in the files?

You could create a new Date field using the formula tool (equal to column 1) -> parse it as a date -> and then use the multi-row tool to fill-down. If you provide a couple of the files (redacted if necessary) then I can show you an example.

P

[chughes49]

It is coming in from an excel file. Here is a sample. I just need to have that one date pulled over to its own column and dragged down somehow. Thanks!

[neilgallen · Accepted solution]

@chughes49 

The solution here is pretty simple, using a sample tool and append records tool!