Copy historical data and append today's date

[mtuwanax]

Hi all,

I'm running a workflow that get's historical data, copies it and appends today's date to Run Date column as shown below, but am unable to make this workflow work. My data has the following format, any one know I can make this work? 

Item	Value	Run Date
A	10	10/05/2021
A	10	11/05/2021
A	10	12/05/2021

[atcodedog05]

Hi @mtuwanax 

I have modified my workflow as per your requirement

Hope this helps 🙂

[danilang]

hi @mtuwanax 

If you're always appending to the same excel output file, there's no need to read in the historical data from the excel file.  Just  read the new data, add the current date and set your output options to "Append to Existing Sheet"

New rows will be added to the sheet after the data that's already there. 

Dan 

[mtuwanax]

Hi @atcodedog05 

Unfortunately, this doesn't solve the issue. 

Thank you for the effort.

[mtuwanax]

Hi @danilang 

Thank you for your answer, but am afraid it doesn't address my issue.

[TheOC]

hey @mtuwanax 

what does @atcodedog05 's solution not solve? Happy to alter his workflow if i know exactly what is missing/needed?

Cheers,
TheOC

[mtuwanax]

Hi @TheOC 

Thank you for the response.

@dougperez solution creates 5 rows of item A, instead of just one row with today's date. I've updated his workflow and amended his input data.