Error: Output Data (271): Error parsing xml: char position=28061531; Message=Start-end tag

[Smitmir]

Alteryx Designer x64

Version: 2022.3.1.395

Error: Output Data (271): Error parsing xml: char position=28061531; Message=Start-end tag

This is a workflow I've been using for months. I input 9 csv files and output as xlsx. The workflow processes all commands then presents the error above on all the outputs.

I've tried different check box combinations of steps 12-14 on the input configuration.

Has anyone experienced this parsing error and resolved the issue? Is there a way for me to locate this char position in alteryx or excel?

[apathetichell]

attach a multi-field formula before the output data. select all fields. replace ">" and "<" try again... sounds like something isn't being rendered with a proper escape chracter based upon that error. Also worth asking - how many records are you sending to excel? Can you write to .yxdb?

[Felipe_Ribeir0]

Hi @Smitmir 

You can locate this position by openning this .csv file inside of notepad++. There is some wrong delimiter on this position i believe.

You can also try to treat read errors as warnings to see what happens.

[Smitmir]

Is there a particular formula I should input into the multi field formula?

[Smitmir]

Thank you however, toggling the check box did not resolve this issue for.

[Smitmir · Accepted solution]

I discovered the excel file Alteryx was writing to corrupted, once I repaired the excel the output worked