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

Alteryx Designer x64

Version: 2022.3.1.395

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.

Input File Config.png Output file Config.png

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?

Workflow

Developer

Developer Tools

Error Message

Output

AMP Engine

AMP-Engine

Accepted answers

Smitmir

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

All comments

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

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

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335