I'm trying to read xml file as csv and I 'm getting following error any idea how to deal with this error?
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
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.