Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

XML Parsing return only one record instead whole.

8 - Asteroid

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.

 

 

 

 

12 - Quasar

@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.

8 - Asteroid

Thanks. It work for me.

Labels