topic Re: Dynamic output - error in Alteryx Designer Desktop Discussions

Dynamic output - error

Til22 — Mon, 05 Jan 2026 00:19:34 GMT

I am trying to dynamically output to excel by inserting the month into the file name. I have set up the output "change the entire path"

And I have specified the sheet in the file name with the three pipes (|||)

but I consistently get the an error asking me to specify the file name

What am I doing wrong?

Thanks in advance.

Re: Dynamic output - error

Qiu — Mon, 05 Jan 2026 04:39:36 GMT

@Til22
I tried to replicate the issue on my end but was not able to.

I did notice that there is yellow portion showing in the data quality bar, indicating null value.

Can you share your sample workflow or partial so we can take a closer look?

https://help.alteryx.com/current/en/designer/workflows/results-window.html#id537162

Re: Dynamic output - error

Til22 — Mon, 05 Jan 2026 05:03:51 GMT

Thank you. I didn't notice the data quality issue and as soon as you mentioned it it realised the problem.

I had been creating dummy records because I was overwriting the file each time, which means I ended up with rows of data without a FilePath

Now that I am creating a new excel file each time I can bypass this dummy record step and now it works perfectly. Thanks for your help pinpointing this issue.

Re: Dynamic output - error

Qiu — Mon, 05 Jan 2026 06:56:57 GMT

@Til22

Good to know it helps.