Skip to Content
0
Former Member
May 12, 2005 at 09:58 AM

Content Conversion- Same keyfield value for two different sub structure

19 Views

Hi,

I have a scenario where the key field value for the 2 substructure of record structure is same.

MY XML structure is like this :

<documentName>

<recordset>

<Header>

<field-nameA1>

<field-nameA2>

<field-nameA3>

<ITM1>

<field-nameB1>

<field-nameB2>

<field-nameB3>

<ROW1>

<field-nameB1>

<field-nameB2>

<field-nameB3>

<ITM2>

<field-nameB1>

<field-nameB2>

<field-nameB3>

<ROW2>

<field-nameB1>

<field-nameB2>

<field-nameB3>

The sample text file is given below where line no. 3 and 5 are different substructure(For ROW1 and ROW2 respectively) with same keyfield value.

"HDR",399,"file",20050302,100642,3289

"ITM1",2,3,4,5,6,7,8,9,10

"ROW",3,4,5,6

"ITM2",2,3,4,5,6,7,8,9,10

"ROW",7,8,9,10

After content conversion I get a XML structure in which there is no ROW2 and all data within the fields of ROW2 are put under ROW1 as the key field values are identical.

In the records only the first field is constant (e.g. ROW).

How to handle such a scenario?

Regards

Satish Chauhan