BizTalk Mapping

Hi Guys,

Hope everyone is doing good.

have a question here…I am mapping the flatfile(CSV) to XML. my flat file looks below

transid transname custname transcode, transamount

1,trans1,transname1,custname1,A,10.00

2,trans2,transname2,custname2,B,20.00

2,trans2,transname2,custname2,C,30.00

2,trans2,transname2,custname2,D,40.00

If transid is same, have to repeat only transcode and transamount only like below.   So it means,if the transid is same for three rows, transid, transname, custname should come only once and transcode and transamount should be repeating. Please help me in this.

<transactions>

       <transaction>

                    <1>

                   <trans1>

                   <transname1>

                    <custname1>

                              <transactiondetails>

                                      <A>

                                      <10.00>

                              <transactiondetails>

            <transaction>

            <transaction>

                     <2>

                      <transname2>

                      <custname2>

                                 <transactiondetails>

                                        <B>

                                        <20.00>

                                </transactiondetails>

                                <transactiondetails>

                                        <c>

                                        <30.00>

                                 </transctiondetails>

                                 <transactiondetails>

                                          <c>

                                           <40.00>

                                  <transactiondetails>

                 <transaction>

<transactions>

Thanks

jith