Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Repair Error Message on opening Excel File with Multiple sheets Output from Alteryx

Tej_Singh
8 - Asteroid

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? 

3 REPLIES 3
apathetichell
19 - Altair

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.

ChrisTX
16 - Nebula
16 - Nebula

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?

apathetichell
19 - Altair

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.

 

Labels
Top Solution Authors