Output Data must specify a sheet name

Hello Everyone, I am trying to have the output file named Dec 12_BWW Sales Report, but for some reason I keep getting that you must specify a sheet name error message. I have attached my workflow and any help would be greatly appreciated.

I have looked at all the other solutions regarding this issue and non seemed to solve my problem.

Thanks in advance,

Cyrus

Change Output FileName.yxmd

Error Message

Accepted answers

danilang

Hi @CSakha

Your output is set to change the entire file path using the period column.

Your Period field currently doesn't include the sheet name

Add the sheet name to end of the string

IF     [Month]='01' THEN 'Dec P12_BWW Sales Report|||Sheet1'

If you need the period field to display in the data, create a new filename field with the sheet name and use this new field as the source for output filename

Dan

All comments

MarqueeCrew

you have this:

C:\Users\csakha\Documents\SandBox\'Test.xlsx|||Sheet1'

but need this:

C:\Users\csakha\Documents\SandBox\Test.xlsx|||Sheet1

Cheers,

Mark

CSakha

Hi Mark,

Thank you for your prompt response. I have tried without the ' ' and it still give me the same error message.

Regards,

Cyrus

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703