Join the Inspire AMA with Joshua Burkhow, March 31-April 4. Ask, share, and connect with the Alteryx community!

Alteryx Designer Desktop Discussions

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

eRROR READING file

srk0609
8 - Asteroid

I'm trying to read xml file as csv and I 'm getting following error any idea how to deal with this error?

srk0609_0-1659388510911.png

Please help. Thank you.

 

Input Data (13) Error reading "S:\accounting\Duco\05-Reconciliations\CPN1_to_Indixis\z.wrk\Aurelien's files\07262022\ROC_XML_MX_FX_C_20220726.xml": Too many fields in record #1349945

1 REPLY 1
Luke_C
17 - Castor
17 - Castor

Look at record 1,349,945. It sounds like there's probably a data issue - an extra field. 

 

You could read in the data with no delimiter (set to \0). Then do a text to columns tool - you should be able to see the data that's causing this issue.

Labels
Top Solution Authors