Forum Discussion

dmoskowitz's avatar
dmoskowitz
Icon for Helper I rankHelper I
4 years ago

How do I append a refreshed file to previous data without losing original data?

I have a source file that gets refreshed every month with new data.  Below is my current flow. It opens a file and then it separately opens the folder containg the file to capture the file details. I...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
4 years ago

dmoskowitz not sure if you want to go that route, I will still stick to the original solution I posted.

 

negi007 I already proposed this solution. FYI

dmoskowitz's avatar
dmoskowitz
Icon for Helper I rankHelper I
4 years ago

Thank you.

 

My original folder has a single file though and that file gets updated every month. I am not sure how your solutions accounts for that. The source file, let's say source.xlsx, does not have a date field in it. I need to add the date field based on when the file was generated. The next month, source.xlsx gets overwritten with new data and I need to append that, along with the generated date field, to last months data.

 

Don't I need to export the data each month as a new file name and then append all the exported files in that folder?

 

Am I missing something?