help with xslt

[cfli1688]

I would like help with a simple transformation:

I am the following xml document:

<Root>
  <FacilitySiteAllDetails>
   <FacilitySite>
      <FacilitySiteID>99999</FacilitySiteID>
      <FacilitySiteTypeName>STATIONARY</FacilitySiteTypeName>
      <FederalFacilityIndicator>N</FederalFacilityIndicator>
      <TribalLandIndicator>N</TribalLandIndicator>
   </FacilitySite>
   <LocationAddress>
      <LocationAddressText>Some Address 1</LocationAddressText>
      <LocalityName>Orlando</LocalityName>
      <CountyStateFIPSCode>09999</CountyStateFIPSCode>
      <CountyName>Orange</CountyName>
      <StateUSPSCode>FL</StateUSPSCode>
      <StateName>Florida</StateName>
      <CountryName>USA</CountryName>
      <LocationZIPCode>888883906</LocationZIPCode>
   </LocationAddress>
  </FacilitySiteAllDetails>
  <FacilitySiteAllDetails>
   <FacilitySite>
      <FacilitySiteID>99999</FacilitySiteID>
      <FacilitySiteTypeName>STATIONARY</FacilitySiteTypeName>
      <FederalFacilityIndicator>N</FederalFacilityIndicator>
      <TribalLandIndicator>N</TribalLandIndicator>
   </FacilitySite>
   <LocationAddress>
      <LocationAddressText>Some Address 2</LocationAddressText>
      <LocalityName>Orlando</LocalityName>
      <CountyStateFIPSCode>08888</CountyStateFIPSCode>
      <CountyName>Apple</CountyName>
      <StateUSPSCode>FL</StateUSPSCode>
      <StateName>Florida</StateName>
      <CountryName>USA</CountryName>
      <LocationZIPCode>999993906</LocationZIPCode>
   </LocationAddress>
  </FacilitySiteAllDetails>
</Root>
 
I would like a xslt to put the 2 records into 1, with 2 addresses:
<Root>
  <FacilitySiteAllDetails>
   <FacilitySite>
      <FacilitySiteName>Towing Service</FacilitySiteName>
      <FacilitySiteTypeName>STATIONARY</FacilitySiteTypeName>
      <FederalFacilityIndicator>N</FederalFacilityIndicator>
      <TribalLandIndicator>N</TribalLandIndicator>
   </FacilitySite>
   <LocationAddress>
      <LocationAddressText>Some Address 1</LocationAddressText>
      <LocalityName>Orlando</LocalityName>
      <CountyStateFIPSCode>09999</CountyStateFIPSCode>
      <CountyName>Orange</CountyName>
      <StateUSPSCode>FL</StateUSPSCode>
      <StateName>Florida</StateName>
      <CountryName>USA</CountryName>
      <LocationZIPCode>888883906</LocationZIPCode>
   </LocationAddress>
   <LocationAddress>
      <LocationAddressText>Some Address 2</LocationAddressText>
      <LocalityName>Orlando</LocalityName>
      <CountyStateFIPSCode>08888</CountyStateFIPSCode>
      <CountyName>Apple</CountyName>
      <StateUSPSCode>FL</StateUSPSCode>
      <StateName>Florida</StateName>
      <CountryName>USA</CountryName>
      <LocationZIPCode>999993906</LocationZIPCode>
   </LocationAddress>
  </FacilitySiteAllDetails>
</Root>

Is it possible with XSLT? What would the xslt look like?
Thanks.

[dorinbogdan]

Welcome to TheScripts TSDN....

Yes, it is possible with XSL.
BUT, we will not provide full source code, it is against the site rules.
We try to help with suggestions and code snippets.
I recommend you this short tutorial, that should take max. 30 minutes to read.

Then, if you need more help, please provide the XSL code to be updated or enhanced as desired.

Thanks,
Dorin.