Unexpected field value when converting XML file

Hi. We have created a graph using the GUI tool to convert XML file to CSV/XLS file. However, when flushing in a lot of data, outputs are broken. In version 4.0.1, some data are converted to “<SEARCH_QUE”, which looks like an angle bracket plus some characters of the field names. In version 4.3, some data are converted with duplicated text, say “aa:[10] bb:[20]” is converted to “aa:[10] bb:[20 bb:[20]”. We have around 800 records when meeting the issue.

Graph settings are as follow:

XMLExtract ----------> UniversalDataWriter or SpreadsheetDataWriter

In XMLExtract:





During file generation, an error message was flashed out.
[Fatal Error] :6:10: The end-tag for element type “Mapping” must end with a ‘>’ delimiter.

Any idea?

Hi Martintangn,

I would like to replicate this issue of the duplicate data on my end could you please provide me with your graph and a sample of the XML structure you use (please use dummy data). Also it would appear you are missing “>” after outPort=“0” which is causing the error.