Overwrite data and change file name date.

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?

Output

Date Time

Accepted answers

binu_acs

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

overwrite_Sheet_03022025.yxmd

DawnDuong

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.

All comments

binu_acs

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

overwrite_Sheet_03022025.yxmd

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.

binu_acs

@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

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703