Dynamic output - error

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.

Error Message

Output

Dynamic Processing

Accepted answers

Qiu

@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

All comments

Qiu

@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.

image.png

Qiu

@Til22

Good to know it helps.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703