Feb 24, 2016 at 08:28 PM

recordsetStructure for nested xml structure

43 Views

Hello experts,

We are receiving an invoice(.csv) file which should be converted to below structure which has 3 levels.

In Content Conversion, i set the parameter 'recordsetStructure = Header,1,Item*,SplitItem,*'. The problem with this is after 1st line item, the system is trying to create another header record.

Expected:

<Invoice>

<Header>

<Item>

<Split Item>

</Split Item>

</Item>

<Item>

<Split Item>

</Split Item>

</Item>

<Item>

<Split Item>

</Split Item>

</Item>

</Header>

<Invoice>

Actual:

<Invoice>

<Header>

<Item>

<Split Item>

</Split Item>

</Item>

</Header>

</Invoice>

<Invoice>

<Item>

<Split Item>

</Split Item>

</Item>

</Invoice>

<Invoice>

<Item>

<Split Item>

</Split Item>

</Item>

</Invoice>

How should i build the parameters to get the expected XML structure?

Regards,

Vishnu