You must specify a sheet name Output excel multiple sheets

[OscarCuevas]

Hi everyone, I need your support, help me!

I tried to run my workflow in the tool Output, I want that the workflow give me the final file in differents sheets, but show me an error

"You must specify a sheet name"

This is my workflow

This is the Output-Configuration

And this is the error

Can you help me? please

[Thableaus]

Hi @OscarCuevas 

You might need to add a Formula tool and create the full path of the File, changing only the Sheet Name (with your Blank Field).

Then you'd use "Change Entire File Path" option, instead of this one you're using now.

Cheers,

[Dynamomo · Accepted solution]

@OscarCuevas I believe that the problem is that you have a blank or null record in the Bank field and so there is no sheet name created.  I was able to replicate your issue when I had a null value in the field I was trying to output for sheetnames.

[OscarCuevas]

Hi Dynamomo

You right, in the column I had various empty records, I fix it putting a Filter Tool that separeted the empty records in order to continue working and let me run my workflow, and yeah! it give me the diferents sheets whit his respective names. thanks