Concatenate Header contents to each detail record and write out flat file

I have the following xml file that I need to transform to a tab-delimited flat file:

<?xml version="1.0"?>
 <root>
  <header>
   <driver_id>driver_id_from_trans</driver_id>
   <vehicle_id>vehicle_id_from_trans</vehicle_id>
   <duty_shift_id>duty_shift_id_from_trans</duty_shift_id>
   <route_id>route_id_from_trans</route_id>
   <cid_terminal_id>cid_terminal_id_from_trans</cid_terminal_id>
  </header>
  <record>
   <longitude>-105.111111</longitude>
   <latitude>39.111111</latitude>
   <date_time>2003/12/10.16:08</date_time>
   <tag_id>tag_id_from_trans_1</tag_id>
   <stop_location_id>stop_location_id_from_trans_1</stop_location_id>
   <fare_type_cd>fare_type_cd_from_trans_1</fare_type_cd>
   <blacklist_cd>blacklist_cd_from_trans_1</blacklist_cd>
  </record>
  <record>
   <longitude>-105.222222</longitude>
   <latitude>39.222222</latitude>
   <date_time>2003/12/10.16:18</date_time>
   <tag_id>tag_id_from_trans_4</tag_id>
   <stop_location_id>stop_location_id_from_trans_4</stop_location_id>
   <fare_type_cd>fare_type_cd_from_trans_4</fare_type_cd>
   <blacklist_cd>blacklist_cd_from_trans_4</blacklist_cd>
  </record>
</root>

I need to concatenate the <header> fields to the front of each <record> as follows:

driver_id_from_trans vehicle_id_from_trans duty_shift_id_from_trans route_id_from_trans cid_terminal_id_from_trans -105.111111 39.111111 2003/12/10.16:08 tag_id_from_trans_1 stop_location_id_from_trans_1 fare_type_cd_from_trans_1 blacklist_cd_from_trans_1
driver_id_from_trans vehicle_id_from_trans duty_shift_id_from_trans route_id_from_trans cid_terminal_id_from_trans -105.222222 39.222222 2003/12/10.16:18 tag_id_from_trans_4 stop_location_id_from_trans_4 fare_type_cd_from_trans_4 blacklist_cd_from_trans_4

Here is the xsl stylesheet that I hoped would work, but no luck:

<?xml version="1.0"?>
<xsl:stylesheet version="1.0"
  xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
  <xsl:output method="text" />
  <xsl:template match="/" >
    <xsl:param name="delim" select="'&#x9;'"/>   <!-- tab     -->
    <xsl:param name="nl"    select="'&#xA;'"/>   <!-- newline -->

    <xsl:for-each select="root/header">
      <xsl:value-of select="normalize-space(driver_id)"/>
      <xsl:value-of select="$delim"/>

      <xsl:value-of select="normalize-space(vehicle_id)"/>
      <xsl:value-of select="$delim"/>

      <xsl:value-of select="normalize-space(duty_shift_id)"/>
      <xsl:value-of select="$delim"/>

      <xsl:value-of select="normalize-space(route_id)"/>
      <xsl:value-of select="$delim"/>

      <xsl:value-of select="normalize-space(cid_terminal_id)"/>
      <xsl:value-of select="$delim"/>

      <xsl:for-each select="root/record">
        <xsl:value-of select="normalize-space(longitude)"/>
        <xsl:value-of select="$delim"/>

        <xsl:value-of select="normalize-space(latitude)"/>
        <xsl:value-of select="$delim"/>

        <xsl:value-of select="normalize-space(date_time)"/>
        <xsl:value-of select="$delim"/>

        <xsl:value-of select="normalize-space(tag_id)"/>
        <xsl:value-of select="$delim"/>

        <xsl:value-of select="normalize-space(stop_location_id)"/>
        <xsl:value-of select="$delim"/>

        <xsl:value-of select="normalize-space(fare_type_cd)"/>
        <xsl:value-of select="$delim"/>

        <xsl:value-of select="normalize-space(blacklist_cd)"/>
        <xsl:value-of select="$delim"/>

        <xsl:value-of select="$nl"/>               <!-- newline -->

      </xsl:for-each>
    </xsl:for-each>

  </xsl:template>
</xsl:stylesheet>

Can someone tweak this for me to get it to work?

TIA

Start Free Trial