XSLT Transforming repeating elements into one while maintaining order

avin

New Member
I am trying to transform some XML using a stylesheet that starts out looking like:\[code\] <m10:RESPONSE_DETAIL> <m10:LINE_NO>001</m10:LINE_NO> <m10:APPR_ITEM_AMT>00000109</m10:APPR_ITEM_AMT> <m10:APPR_ITEM_TAX>00000009</m10:APPR_ITEM_TAX> <m10:TAX_FLAG>N</m10:TAX_FLAG> </m10:RESPONSE_DETAIL> <m10:RESPONSE_DETAIL> <m10:LINE_NO>002</m10:LINE_NO> <m10:APPR_ITEM_AMT>00000109</m10:APPR_ITEM_AMT> <m10:APPR_ITEM_TAX>00000009</m10:APPR_ITEM_TAX> <m10:TAX_FLAG>N</m10:TAX_FLAG> </m10:RESPONSE_DETAIL> <m10:RESPONSE_DETAIL> <m10:LINE_NO>003</m10:LINE_NO> <m10:APPR_ITEM_AMT>00000100</m10:APPR_ITEM_AMT> <m10:APPR_ITEM_TAX>00000000</m10:APPR_ITEM_TAX> <m10:TAX_FLAG>N</m10:TAX_FLAG> </m10:RESPONSE_DETAIL> \[/code\]Into this:\[code\] <m10:RESPONSE_DETAIL> <m10:LINE_NO>001</m10:LINE_NO> <m10:APPR_ITEM_AMT>109</m10:APPR_ITEM_AMT> <m10:APPR_ITEM_TAX>9</m10:APPR_ITEM_TAX> <m10:TAX_FLAG>N</m10:TAX_FLAG> <m10:LINE_NO>002</m10:LINE_NO> <m10:APPR_ITEM_AMT>109</m10:APPR_ITEM_AMT> <m10:APPR_ITEM_TAX>9</m10:APPR_ITEM_TAX> <m10:TAX_FLAG>N</m10:TAX_FLAG> <m10:LINE_NO>003</m10:LINE_NO> <m10:APPR_ITEM_AMT>100</m10:APPR_ITEM_AMT> <m10:APPR_ITEM_TAX>0</m10:APPR_ITEM_TAX> <m10:TAX_FLAG>N</m10:TAX_FLAG> </m10:RESPONSE_DETAIL>\[/code\]I am not too strong in xslt so this may be a basic but everything I have tried so far is coming back with:\[code\] <m10:RESPONSE_DETAIL> <m10:LINE_NO>001</m10:LINE_NO> <m10:LINE_NO>002</m10:LINE_NO> <m10:LINE_NO>003</m10:LINE_NO> <m10:APPR_ITEM_AMT>109</m10:APPR_ITEM_AMT> <m10:APPR_ITEM_AMT>109</m10:APPR_ITEM_AMT> <m10:APPR_ITEM_AMT>100</m10:APPR_ITEM_AMT> <m10:APPR_ITEM_TAX>9</m10:APPR_ITEM_TAX> <m10:APPR_ITEM_TAX>9</m10:APPR_ITEM_TAX> <m10:APPR_ITEM_TAX>0</m10:APPR_ITEM_TAX> <m10:TAX_FLAG>N</m10:TAX_FLAG> <m10:TAX_FLAG>N</m10:TAX_FLAG> <m10:TAX_FLAG>N</m10:TAX_FLAG> </m10:RESPONSE_DETAIL> \[/code\]Any suggestions would really be appreciated...Thank You in advance
 
Back
Top