How to adjust Dynamic file name save location (Novice)

Hi everyone, I appreciated your valued support and I hope you can help me!

With the help of all the resources on here I managed to create a workflow and have a dynamic filename based on filename+todays date. The issue I have is that it keeps saving the .xlsx output in the same folder as the .yxmd file. I did not have this issue before the filename was dynamic, then I could just select the correct location via the output tool.

Where do I make the error?.

It does not use the below folder, Instead it puts the output in the same folder where the workflow is saved.

Workflow

Output

Accepted answers

jrgo

@Pingu

I don't think there is an alternative solution. The other options in the Output tool to make it create a dynamically named file would target the sheet name, not the file name. So in this case, you have to use the "change entire file path" option and you'll need to supply it with a complete location. If the directory location is always the same, just concatenate it to the beginning of your [FileName] expression.

'C:\Users\somebody\Desktop\Alteryx Output test\'
+ '_Vemo_'
+ [DateToday]
+ '.xlsx|||Sheet1'

All comments

jrgo

Hi @Pingu

It's because you have the option set to change the entire file path.

Unfortunately, this is the option that you'll need to keep it as if you're also specifying the sheet name. So what you have to do is update the formula that creates the filename and also include the directory path.

Hope this helps!

Jimmy
Teknion Data Solutions

Pingu

Thanks jrgo,

So if it states a whole directory path - Alteryx will recognize and use that one instead of the current folder? I will look into your suggestion and reply if i got it to work.

To which other solution do you refer? In thise case the sheetname does not have to be specified necessarily, it is more that this solution is more flexible in case there will be more sheets / different sheetnames possibly later on.

jrgo

@Pingu

'C:\Users\somebody\Desktop\Alteryx Output test\'
+ '_Vemo_'
+ [DateToday]
+ '.xlsx|||Sheet1'

Quick Links

This months top contributors

LanisC 335

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177