Flat file grouping with one field - No Key

[former_member188791]

Hi Group,

Need one help to get below grouping correct on mapping,.

I am getting flat file without any key I need to group header and Item as per below , I am getting header Item correctly but Items mapping logic not getting correctly , any suggestions here

BLDAT            BUDAT       BUKRS    HKNONT  DMBTR
20191219         20191219     NL13    1002     1500
                                      1003      600
                                      1004      500
                                      1005      400


20191219         20191219     NL14    2002     1500
                                      2003      600
                                      2004      500
                                      2005      400






Output


<Record>
 <Header>
   <BLDAT>20191219</BLDAT>
   <BUDAT>20191219</BUDAT>
   <BUKRS>NL13</BUKRS>
   <HKONT>1002/<HKONT>
   <DMBTR>1500</DMBTR>
<Item>
   <BLDAT> </BLDAT>
   <BUDAT> </BUDAT>
   <BUKRS> </BUKRS>
   <HKONT>1003/<HKONT>
   <DMBTR>600</DMBTR>
</Item>


<Item>
   <BLDAT> </BLDAT>
   <BUDAT> </BUDAT>
   <BUKRS> </BUKRS>
   <HKONT>1004/<HKONT>
   <DMBTR>500</DMBTR>
</Item>
<Item>
   <BLDAT> </BLDAT>
   <BUDAT> </BUDAT>
   <BUKRS> </BUKRS>
   <HKONT>1005/<HKONT>
   <DMBTR>400</DMBTR>
</Item>


</Header>


<Header>
   <BLDAT>20191219</BLDAT>
   <BUDAT>20191219</BUDAT>
   <BUKRS>NL14</BUKRS>
   <HKONT>2002/<HKONT>
   <DMBTR>1500</DMBTR>
<Item>
   <BLDAT> </BLDAT>
   <BUDAT> </BUDAT>
   <BUKRS> </BUKRS>
   <HKONT>2003/<HKONT>
   <DMBTR>600</DMBTR>
</Item>


<Item>
   <BLDAT> </BLDAT>
   <BUDAT> </BUDAT>
   <BUKRS> </BUKRS>
   <HKONT>2004/<HKONT>
   <DMBTR>500</DMBTR>
</Item>
<Item>
   <BLDAT> </BLDAT>
   <BUDAT> </BUDAT>
   <BUKRS> </BUKRS>
   <HKONT>2005/<HKONT>
   <DMBTR>400</DMBTR>
</Item>


</Header>

[former_member188791]

Hi Group

Any suggestion here on my query.