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

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