Repair Error Message on opening Excel File with Multiple sheets Output from Alteryx
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Team,
Kindly note I created a merge Excel output with multiple sheets from 3 different Excel files having multiple sheets.
On opening the merge Excel I am first getting mesage "We found problem with some content in..." with a Yes or No button. On Clicking "Yes" then I get a second message as repaired records with a "Recovered_Sheet1" in the output.
See attached Error screenshots for your reference.
Can anyone advise why I am getting these errors or messages?
- Labels:
- Batch Macro
- Error Message
- Output
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
That file wont work. this is something wrong with your alteryx workflow - and the file you are creating is broken. You'll need to share more information on your workflow - and how you are creating your filenames with sheet/range etc.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
In the second screenshot, send the information from the link "Click to view log..."
Agree with @apathetichell we'll need more details from your workflow. Does your XLSX file name or Sheet name contain any unusual characters?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
As hinted at by @ChrisTX - your excel file name/sheet combo should be {{filename}}|||`sheetname` the ` is critical here - it is not the '. this can work as {{filenaem}}|||sheetname - when sheetname has no special characters. You can also use one | instead of ||| - and some versions of Server internally used | - and woud not accept ||| for reasons.
You also cannot use output data and render with the same file in the same workflow - unless you create the sheet first with render and then output data over it.
