Groovy to convert linear structure to Header and lineitem

[former_member851588]

Hi All,

could you please provide me either groovy or XSLT to convert the input file to output format.

<Output>
	<Row>
		<H1>H1</H1>
		<H2>H2</H2>
		<I1>I11</I1>
		<I2>I12</I2>
	</Row>
	<Row>
		<H1>H3</H1>
		<H2>H4</H2>
		<I1>I21</I1>
		<I2>I22</I2>
	</Row>
	<Row>
		<H1>H1</H1>
		<H2>H2</H2>
		<I1>I31</I1>
		<I2>I32</I2>
	</Row>
	<Row>
		<H1>H3</H1>
		<H2>H4</H2>
		<I1>I41</I1>
		<I2>I42</I2>
	</Row>
</Output>

<Output>
	<Row>
		<Header>
			<H1>H1</H1>
			<H2>H2</H2>
		</Header>
		<Item>
			<I1>I11</I1>
			<I2>I12</I2>
		</Item>
		<Item>
			<I1>I31</I1>
			<I2>I32</I2>
		</Item>
	</Row>
	<Row>
		<Header>
			<H1>H3</H1>
			<H2>H4</H2>
		</Header>
		<Item>
			<I1>I21</I1>
			<I2>I22</I2>
		</Item>
		<Item>
			<I1>I41</I1>
			<I2>I42</I2>
		</Item>
	</Row>
</Output>

Regards,

[MortenWittrock]

Hi Pradeep

What have you tried so far and how did it not work? If you have a script or a stylesheet that doesn't work, post it and we can help you debug it.

Regards,

Morten

[daviddasilva]

Hi,

You can achieve this easily by using message mapping. Create the target xsd as you need and then map accordingly.

Alternatively, as Morten suggested, please post the XSLT you are currently using.

Kind regards,

David