Dynamic output - error

[Til22]

Hi

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.

[Qiu · Accepted solution]

@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

[Til22]

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.

[Qiu]

@Til22 

Good to know it helps.