Output Data must specify a sheet name

[CSakha]

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

[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

[danilang · Accepted solution]

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

[CSakha]

Thank you so much @danilang.

It worked perfectly!!!

Regards,

Cyrus

[arce88]

By end of string do you mean replacing "Dec P12_BWW Sales report" with 

'Dec P12_BWW Sales Report|||Sheet1'
?

[ericiver]

Hi!

I tried to follow the steps and it's working also, but why is it saving in my drive C though I specified to save the file in our shared folder (Network folder).

Hope you can shed some light on this.

Thank you.

[DataAnalyst1]

The output node has been set to replace the file path with the file path in the workflow column. Therefore you need to make sure the Pile-path in the workflow column is the shared drive File-path. Does that make sense ? 

What is in the Output node is going to be replaced and is somewhat redundant. 

[Monica_Gaffney]

i'M SO GLAD YOU ASKED THIS!!!

[jainna19121990]

Hi!

Can you please explain through workflow example? 

I am still not able to resolve this. I have added another called Filename and added Date and sheetname like 

"Sheet1" + " " + [Date]

Now the error is that its invalid sheetname.