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

What you wish to achieve is called "Muenchian Grouping" and done through a custom XSLT in a MAP. Refer Sandro's article http://code.msdn.microsoft.com/windowsdesktop/Muenchian-Grouping-and-790347d2

So create a FFDASM schema to parse your file into XML and then apply the muenchian grouping through a map on the receive port to get the final results.

Regards.

• Proposed as answer by Maheshkumar S TiwariMVP 2 hours 55 minutes ago

What you wish to achieve is called "Muenchian Grouping" and done through a custom XSLT in a MAP. Refer Sandro's article http://code.msdn.microsoft.com/windowsdesktop/Muenchian-Grouping-and-790347d2

So create a FFDASM schema to parse your file into XML and then apply the muenchian grouping through a map on the receive port to get the final results.

Regards.

• Proposed as answer by Maheshkumar S TiwariMVP Saturday, July 12, 2014 7:31 AM

What you wish to achieve is called "Muenchian Grouping" and done through a custom XSLT in a MAP. Refer Sandro's article http://code.msdn.microsoft.com/windowsdesktop/Muenchian-Grouping-and-790347d2

So create a FFDASM schema to parse your file into XML and then apply the muenchian grouping through a map on the receive port to get the final results.

Regards.

• Proposed as answer by Maheshkumar S TiwariMVP Saturday, July 12, 2014 7:31 AM
• Marked as answer by Angie xuMicrosoft contingent staff, Moderator 4 hours 57 minutes ago

What you wish to achieve is called "Muenchian Grouping" and done through a custom XSLT in a MAP. Refer Sandro's article http://code.msdn.microsoft.com/windowsdesktop/Muenchian-Grouping-and-790347d2

So create a FFDASM schema to parse your file into XML and then apply the muenchian grouping through a map on the receive port to get the final results.

Regards.

• Proposed as answer by Maheshkumar S TiwariMVP Saturday, July 12, 2014 7:31 AM
• Marked as answer by Angie xuMicrosoft contingent staff, Moderator Tuesday, July 15, 2014 5:30 AM

What you wish to achieve is called "Muenchian Grouping" and done through a custom XSLT in a MAP. Refer Sandro's article http://code.msdn.microsoft.com/windowsdesktop/Muenchian-Grouping-and-790347d2

So create a FFDASM schema to parse your file into XML and then apply the muenchian grouping through a map on the receive port to get the final results.

Regards.

• Proposed as answer by Maheshkumar S TiwariMVP Saturday, July 12, 2014 7:31 AM
• Marked as answer by Angie xuMicrosoft contingent staff, Moderator Tuesday, July 15, 2014 5:30 AM