Output to a different customized folder

[Gurinder27]

I have created a formula took to have a filename example './'+"Opened cases"+ dateformula ||| sheet 1. On output tool i just added .xlsx on write to file or database  and at the bottom on take file/table name from field  selected change entire file path and field containing filename (please refer to the attachment ) however i tried all combination for the file to be saved in a custom folder but its going to a different folder and i don't know what's going on please help

[Gumsmenezes]

The structure is correct @Gurinder27, since you chose to start with a ".", the only thing that could be causing this is that the workflow you're running is not saved where it should.

For example:

- The workflow (yxmd or yxwz) is saved at "C:\Users\Gurinder27\Desktop\Test" and the formula results in "./Opened week ending 03.03.2025.xlsx|||Sheet1".

- Your results will be saved as "C:\Users\Gurinder27\Desktop\Test\Opened week ending 03.03.2025.xlsx|||Sheet1"

Double check where the workflow is saved.

[alexnajm]

Agreed with @Gumsmenezes - also if it’s running without error, you can check your workflow results log at the bottom to see where it ends up

[Gurinder27]

Thank you both for the response however its going to desktop/alteryxworkflow which i don't want . I want it to go to Folder Named Open in Desktop that's were my challenge is

[alexnajm]

Then adjust your Formula to go to that folder - without knowing your folder structure, we cannot advise on what the relative path would look like so here's some guidance: How To: Use Relative Paths