Separate excel files per facility

[jlfromm]

I have an excel database that I brought in, I have sorted out the information I need and have it all in order. I have around 96 different providers in the file and each provider has around 2 thousand lines lines of data I need,  I would like to output each one of the providers into a separate file or one excel file with a tab for each providers. 

[apathetichell]

https://community.alteryx.com/t5/Interactive-Lessons/Writing-Data/ta-p/74561

[binuacs]

@jlfromm sample attached

[jlfromm]

  When I do that I am getting and error Target Excel file maybe corrupted. Cannot find required file or element 

@binuacs 

 

[apathetichell]

One of your tab names may have an unsupported excel tab character - or may be blank/null.

[binuacs]

@jlfromm Change the output options to Overwirte Sheet or Range

[jlfromm]

@binuacs  I changed it to Overwrite Sheet or range and still the same error

[binuacs]

@jlfromm Make sure you dont have any blank/Null values in the billing providers name