kieters c wrote:
Thank you. I did not see the one although I tried to check on all the
brackets. I found another one missing two lines down.
I used XML Notepad 2007 to do the transformation and the result remain
the same as previously reported. Only sample_date_time is seperated
and all other is include in result. I added all the other that should
be grouped with sample_date_time but it made not difference.
I just tried it with the last sample data "flat file" (it is not flat,
it is still xml) and changed your sample to contain different groups for
the combination sample_date_time and cp_name. It worked perfectly well
for me. The sample data I used after I removed some of the noise was this:
<dataroot>
<sample>
<sample_date_time>20070101</sample_date_time>
<cp_name>Neutr. Sump WTPE</cp_name>
<imis_cp_ext>2300</imis_cp_ext>
<dischg_sample_cd/>
</sample>
<sample>
<sample_date_time>20070102</sample_date_time>
<cp_name>Neutr. Sump WTPE</cp_name>
<imis_cp_ext>2300</imis_cp_ext>
<dischg_sample_cd/>
</sample>
<sample>
<sample_date_time>20070101</sample_date_time>
<cp_name>Neutr. Sump WTPE</cp_name>
<imis_cp_ext>2300</imis_cp_ext>
<dischg_sample_cd/>
</sample>
<sample>
<sample_date_time>20070101</sample_date_time>
<cp_name>22Neutr. Sump WTPE</cp_name>
<imis_cp_ext>2300</imis_cp_ext>
<dischg_sample_cd/>
</sample>
<sample>
<sample_date_time>20070101</sample_date_time>
<cp_name>33Neutr. Sump WTPE</cp_name>
<imis_cp_ext>2300</imis_cp_ext>
<dischg_sample_cd/>
</sample>
<sample>
<sample_date_time>20070101</sample_date_time>
<cp_name>22Neutr. Sump WTPE</cp_name>
<imis_cp_ext>2300</imis_cp_ext>
<dischg_sample_cd/>
</sample>
</dataroot>
which returned the following output when run against the stylesheet:
(note the added numbers for cp_name attributes to make them distinguishable)
<submission imis_company_code="0001843309" ws_name="LENNOX">
<sample sample_date_time="20070101">
<result cp_name="Neutr. Sump WTPE" imis_cp_ext="2300"
dischg_sample_cd=""/>
<result cp_name="Neutr. Sump WTPE" imis_cp_ext="2300"
dischg_sample_cd=""/>
</sample>
<sample sample_date_time="20070102">
<result cp_name="Neutr. Sump WTPE" imis_cp_ext="2300"
dischg_sample_cd=""/>
</sample>
<sample sample_date_time="20070101">
<result cp_name="22Neutr. Sump WTPE" imis_cp_ext="2300"
dischg_sample_cd=""/>
<result cp_name="22Neutr. Sump WTPE" imis_cp_ext="2300"
dischg_sample_cd=""/>
</sample>
<sample sample_date_time="20070101">
<result cp_name="33Neutr. Sump WTPE" imis_cp_ext="2300"
dischg_sample_cd=""/>
</sample>
</submission>
which, as you can see, is grouped by both sample_date_time and cp_name
(i.e., if both are concatenated the same, they are grouped together).
Cheers,
-- Abel Braaksma
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--