XML Parsing return only one record instead whole.

rohit782192

Hello,

I have one Sample XML as below.

<Record>

<Name>George Washington</Name>

<Party>No party</Party>

<From>1789-04-30</From>

<To>1797-03-04</To>

</Record>

<Record>

<Name>John Adams</Name>

<Party>Federalist</Party>

<From>1797-03-04</From>

<To>1801-03-04</To>

</Record>

When we Parse through input tool only one record is returned instead of two record.

Can anyone suggest what is wrong.

Attached the workflow and xml for reference.

record.xml

SampleXML.yxmd

vizAlter

@rohit782192 —You are showing two independent rows (branches) instead of capturing them into one parent (root), hence it was creating issue at line#8 for assuming that Extra content at the end of the document.

You may take help from any online xml editor (example: https://xmlgrid.net/) to see what is wrong in your file.

Hope the attached solution would be helpful.

<?xml version="1.0" encoding="UTF-8"?>
<items>
	<Record>
		<Name>George Washington</Name>
		<Party>No party</Party>
		<From>1789-04-30</From>
		<To>1797-03-04</To>
	</Record>
	<Record>
		<Name>John Adams</Name>
		<Party>Federalist</Party>
		<From>1797-03-04</From>
		<To>1801-03-04</To>
	</Record>
</items>

If this post assists in resolving the question, please mark it "Like", or "Solved" if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

XML Parsing_Corrected.yxzp