Overwrite data and change file name date.

[LukeAlteryx]

I am having an issue where I want to replace data in a specified sheet & range every day, and for this I use the output tool.

But I also want to change the title date which also requires a formula and the use of the output tools "take file/table name from field" option. 

Is there a way I could do both? Because when I try both options with the output tool only one of then works at a time. Thanks

For extra points, the file is put into a new month folder at the start of the month. Is there a way to have that part of the workflow change the folder location automatically as well?

[binuacs · Accepted solution]

@LukeAlteryx you need to use the Change Entire file path option in the output tool

[LukeAlteryx]

Hello, I did use that and when I did, it doesn't correctly overwrite the sheet. The file that's outputted is just the raw data file with the new name. And the file I want to be updated isnt in the new output file. 

[binuacs]

@LukeAlteryx can you upload a sample file and expected output file for a better understanding

[LukeAlteryx]

Let me work on that to try and show what im trying to do. 

[DawnDuong · Accepted solution]

hi @LukeAlteryx 

If I may hazard a guess: the reason why only 1 works at a time because you are running into mutually exclusive logic issue:

1) The current file has the name ranged.

2) The new file that you tried to write to does not have that new range (by default, it's new...)

So one way to work around is to just update the range. and then do a separate cmmd script or otherwise rename the file.

Dawn.