AnsweredAssumed Answered

How to set Data Process's Split Document

Question asked by kenta.a.nakai on Oct 7, 2016
Latest reply on Oct 9, 2016 by Srinivas Chandrakanth Vangari

I'd like to convert from XML to CSV as below style.

I use Data Process Shape's Split Document function, but it doesn't work correctly.

Can you please check my configuration?

 

<Source XML> 

<Group>
   <GroupName>TestGroup</GroupName>
   <GroupCode>Test111</GroupCode>
   <Child>
      <ChildName>ChildName1</ChildName>
      <ChildCode>ChildCode1</ChildCode>
   </Child>
   <Child>
      <ChildName>ChildName2</ChildName>
      <ChildCode>ChildCode2</ChildCode>
   </Child>
   <Child>
      <ChildName>ChildName3</ChildName>
      <ChildCode>ChildCode3</ChildCode>
   </Child>
</Group>

 

<Expected CSV>

GroupName, GroupCode,ChildName,ChildCode

TestGroup,Test111,ChildName1,ChildCode1

TestGroup,Test111,ChildName2,ChildCode2

TestGroup,Test111,ChildName3,ChildCode3

 

Outcomes