RE: RE: Help needed to transform in data joining

You're much more likely to get help if you can cut the problem down to a
manageable size. Presenting neatly indented code that one can quickly scan
also increases the probability that someone will decide to take a look at
the problem. You might also find that in doing this, you gain insights that
help you to solve it for yourself. 

Michael Kay
http://www.saxonica.com/

> -----Original Message-----
> From: Kota, Ganesh [mailto:gkota@xxxxxxxx] 
> Sent: 06 November 2006 22:58
> To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
> Subject:  RE: Help needed to transform in data joining
> 
>  
> I have very large merged XML document consists of two big XML 
> child elements(test/results/envelope:Envelope and 
> test/results/processRequestsAsDOMResponse ). 
> I have to transform this entire document structure as 
> 'envelope:Envelope' first element with few required values 
> from second element. 
> I need help to build the source document key function.It's 
> not able to retrieve the key value.I attached XSL and XML file. 
> I will appreciate if you help me to proceed further. 
> 
> Here is my XSL file : 
> <xsl:stylesheet version="1.0"
> xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
> xmlns:envelope="http://schemas.xmlsoap.org/soap/envelope/"
> extension-element-prefixes=""> 
> 
> <!-- <xsl:key name="DCHorseID"
> match="test/results/processRequestsAsDOMResponse/result/server
> /responses
> /Session.getDocumentRs/session/data/equinedata/coverages/horse"
> use="@id"/>-->
> <xsl:key name="DCHorseID" match="//horse" use="@id"/> 
> 
> <xsl:template match="/">
> <session>
> <!--<xsl:value-of select="key('DCHorseID', 'h1')"/>--> <data> 
> <quote> <quotedetail> <quotedetailrisk> <xsl:for-each 
> select="test/results/envelope:Envelope/envelope:Body/session/d
> ata/quote/
> quotedetail/quotedetailrisk/animalquotedetailrisk"> 
> <xsl:variable name="UIHorseID"> <xsl:value-of select="@id"/> 
> </xsl:variable> <animalquotedetailrisk> <horse><xsl:value-of 
> select="$UIHorseID"/></horse> <ratinganimalcoverage> 
> <xsl:attribute name="id"> <xsl:value-of 
> select="ratinganimalcoverage/@id">
> </xsl:value-of>
> </xsl:attribute>
> <ratingasd>
> <xsl:attribute name="id">
> <xsl:value-of select="ratinganimalcoverage/ratingasd/@id">
> </xsl:value-of>
> </xsl:attribute>
> <baseRate>
> <xsl:value-of select="key('DCHorseID',
> $UIHorseID)/HorsePrivateASnDRate"/>
> </baseRate>
> </ratingasd>
> </ratinganimalcoverage>
> </animalquotedetailrisk>
> </xsl:for-each>
> </quotedetailrisk>
> </quotedetail>
> </quote>
> </data>
> </session>
> </xsl:template>
> </xsl:stylesheet> 
> 
> XML File: 
> 
> <?xml version="1.0" encoding="UTF-8"?>
> <test>
> <results>
> <soapenv:Envelope
> xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
> xmlns:xsd="http://www.w3.org/2001/XMLSchema"
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
> <soapenv:Body>
> <session>
> <properties caption="EQM Master Page" dateModified="2006-10-25"
> engineVersion="2.0.0"
> manuscript="RC7782DF3-CC74-4A0B-B8E2-C5D406BDE87A"/>
> <data id="d5367B557842F4D25BD5D4C918B5A48E5">
> <TotalResult>0</TotalResult>
> <CurrentQuoteReferenceId/>
> <issuance id="iC1DD6221700C42D4ADC487A166943BA0"/>
> <submission id="sB65352BDDD5342D4920E97429BE9D4C7">
> <Comments/>
> <CommissionPercent/>
> <CompanyName/>
> <Dba/>
> <Email/>
> <Fax/>
> <Fein/>
> <Name>jaf</Name>
> <Status>New</Status>
> <Website/>
> <ReadOnlyName>jaf</ReadOnlyName>
> <SubmissionId>3805</SubmissionId>
> <ShowProvinces/>
> <ShowStates>1</ShowStates>
> <SelectedQuoteId/>
> <SicCode/>
> <PrimaryPhone/>
> <StatusChangeType/>
> <agency id="aB3F3E68937394BA9A7693A344196B6B1">
> <address>
> <address1/>
> <address2/>
> <city/>
> <state/>
> <ZipCode/>
> </address>
> <Code>11</Code>
> <ContactEmail/>
> <ContactName/>
> <ContactPrimaryPhone/>
> <Fax/>
> <name/>
> <phoneNumber/>
> <phoneExtension/>
> <profitcenter id="p033322B8568842CEB1AE4ED24032A20C">
> <Number/>
> <Name/>
> </profitcenter>
> </agency>
> <contact id="cE53B37297B364673A665BE884E2DA974">
> <Name/>
> <PrimaryPhone/>
> </contact>
> <moreinsureds id="mDD0F38316420466689C108A12B1F34A6">
> <DBA/>
> <Name/>
> <MoreInsuredIndicator>0</MoreInsuredIndicator>
> </moreinsureds>
> <primaryinsuredaddress id="p9CD0FEC05DFB430AA7E09E7A231101F5">
> <address>
> <State>CO</State>
> <Address1>florence</Address1>
> <Address2/>
> <City>flroen</City>
> <Country>UnitedStates</Country>
> <Province>--Select--</Province>
> <ZipCode>11</ZipCode>
> <County/>
> </address>
> <TaxLocationCode/>
> </primaryinsuredaddress>
> <underwriter id="u6E40B24EBDF04FAA8CD99333C9CD13FB">
> <Name>VirginiaCardenas</Name>
> </underwriter>
> <alternatemailingaddress id="aC77982F7B84A46848147EEF075FB9DBA">
> <address>
> <Address1/>
> <Address2/>
> <City/>
> <Country>UnitedStates</Country>
> <Province>--Select--</Province>
> <State/>
> <ZipCode/>
> </address>
> <Dba/>
> <Name/>
> <PrimaryPhone/>
> <AlternateMailingIndicator>0</AlternateMailingIndicator>
> </alternatemailingaddress>
> <reasons id="r59724CF57C8D4C56933FD48481F4B5D0">
> <WithdrawReason/>
> <DeclineReason>--Select--</DeclineReason>
> <ResubmitReason/>
> <PlacedElsewhereOther/>
> <PlacedElsewhereReason/>
> <PlacedElsewhereCompany/>
> <DeclineReasonOther/>
> </reasons>
> <underwritinginput id="uF58447BE0F2440898B059B1FAE093668">
> <UnderwritingInputOwnedHorses/>
> <UnderwritingInputAnimalDeaths>0</UnderwritingInputAnimalDeaths>
> <UnderwritingInputInsuranceHistory/>
> <UnderwritingInputSubstantiationOfValues/>
> <UnderwritingInputInsuranceHistoryExplanation/>
> <UnderwritingInputCauseOfDeath/>
> </underwritinginput>
> </submission>
> <ApplicationIdentifier/>
> <KY>${PrimaryInsuredAddress.State}=='KY'</KY>
> <StateIfStatementsAL>${PrimaryInsuredAddress.State}=='AL'</Sta
> teIfStatem
> entsAL> 
> <StateIfStatementsAR>${PrimaryInsuredAddress.State}=='AR'</Sta
> teIfStatem
> entsAR> 
> <StateIfStatementsCA>${PrimaryInsuredAddress.State}=='CA'</Sta
> teIfStatem
> entsCA> 
> <StateIfStatementsDE>${PrimaryInsuredAddress.State}=='DE'</Sta
> teIfStatem
> entsDE> 
> <StateIfStatementsFL>${PrimaryInsuredAddress.State}=='FL'</Sta
> teIfStatem
> entsFL> 
> <StateIfStatementsGA>${PrimaryInsuredAddress.State}=='GA'</Sta
> teIfStatem
> entsGA> 
> <StateIfStatementsIL>${PrimaryInsuredAddress.State}=='IL'</Sta
> teIfStatem
> entsIL> 
> <StateIfStatementsKS>${PrimaryInsuredAddress.State}=='KS'</Sta
> teIfStatem
> entsKS> 
> <StateIfStatementsLA>${PrimaryInsuredAddress.State}=='LA'</Sta
> teIfStatem
> entsLA> 
> <StateIfStatementsMN>${PrimaryInsuredAddress.State}=='MO'</Sta
> teIfStatem
> entsMN> 
> <StateIfStatementsMO>${PrimaryInsuredAddress.State}=='MO'</Sta
> teIfStatem
> entsMO> 
> <StateIfStatementsMS>${PrimaryInsuredAddress.State}=='MS'</Sta
> teIfStatem
> entsMS> 
> <StateIfStatementsNC>${PrimaryInsuredAddress.State}=='NC'</Sta
> teIfStatem
> entsNC> 
> <StateIfStatementsND>${PrimaryInsuredAddress.State}=='ND'</Sta
> teIfStatem
> entsND> 
> <StateIfStatementsNJ>${PrimaryInsuredAddress.State}=='NJ'</Sta
> teIfStatem
> entsNJ> 
> <StateIfStatementsNY>${PrimaryInsuredAddress.State}=='NY'</Sta
> teIfStatem
> entsNY> 
> <StateIfStatementsSC>${PrimaryInsuredAddress.State}=='SC'</Sta
> teIfStatem
> entsSC> 
> <quote id="qA66481E0EFF2411FBAA7192E3C2A5D71">
> <Description>qd1</Description>
> <PolicyEffectiveDate>11/1/2006</PolicyEffectiveDate>
> <EndorsementDate/>
> <EndorsementNumber/>
> <PolicyExpirationDate>11/1/2007</PolicyExpirationDate>
> <PolicyNumber/>
> <PremiumIndication/>
> <PrimaryRatingState>OH</PrimaryRatingState>
> <ProcessDate/>
> <QuoteEffectiveDate>2006-10-25</QuoteEffectiveDate>
> <QuoteId>1</QuoteId>
> <QuoteModificationDate/>
> <QuoteStatus>Quote</QuoteStatus>
> <TotalPremium/>
> <TransactionCode/>
> <TransactionDate/>
> <QuoteTransactionStatus/>
> <TransactionType>NewBusiness</TransactionType>
> <QuoteExpirationDate/>
> <QuoteGUI>qA66481E0EFF2411FBAA7192E3C2A5D71</QuoteGUI>
> <policyDetailsChkBox>1</policyDetailsChkBox>
> <availablelob id="a233A49A80D514DB5B70BEEB23D2CAA56">
> <EquineMortality/>
> <FarmProperty/>
> <Watercraft/>
> <CommericalAuto/>
> <FarmGeneralLiability/>
> <ScheduledPersonalProperty/>
> <AgriGuard/>
> <CareCustodyAndControl/>
> <IdentityTheft/>
> <EquipmentBreakdown/>
> <CommercialLiability/>
> <CommercialCrime/>
> </availablelob>
> <quotedetail id="qCE9C706FF7FF4329A34D8F2CAC108EAE">
> <quotedetailcoverage id="q7D087515394E43E984D710062652BEB7">
> <eqmquotedetailcoverage id="e68148CF4C1304B6D8B4F6C7F959B1F3D">
> <barrennessprofoal id="b0AD6912EB33B4341BBE9E9F64D45EE76">
> <barrennessProfoal>0</barrennessProfoal>
> <barrennessProfoalTypicalDuration/>
> <barrennessProfoalSpecifiedDuration/>
> </barrennessprofoal>
> <fullmortality id="fF48B0ED0A7F44C3982B6F51CBCD1D304">
> <fullMortality>1</fullMortality>
> </fullmortality>
> <profoal id="p11DE7438B4A346CCAB4FF2B2AF30C7A7">
> <profoal>0</profoal>
> <profoalTypicalDuration/>
> <profoalSpecifiedDuration/>
> </profoal>
> <specifiedperils id="sEB50C7936BF44E6F8981DA58F86BD2C2">
> <specifiedPerils>0</specifiedPerils>
> <specPerilsWaivePremium>0</specPerilsWaivePremium>
> <specPerilsMinPremium>200.00</specPerilsMinPremium>
> </specifiedperils>
> <stallionavailablity id="s0335611F9A944710ACE3C57D40CD7FAB">
> <stallionAvailablity>0</stallionAvailablity>
> <stallionAvailBreedingSeason/>
> </stallionavailablity>
> <stallioncongenitalinfertility id="s1365729A25AC42B188C8CBD609E8708A">
> <stallionCongenitalInfertility>0</stallionCongenitalInfertility>
> <stallionConInfertMaxNoOfMares/>
> <stallionCongenitalCoverageBreedingSeason/>
> <stallionCongenitalCoverageForm/>
> </stallioncongenitalinfertility>
> <stallionlossofincome id="sEE5B5FC31AEF4B1B87AD64CB3F1FC060">
> <stallionLossOfIncome>0</stallionLossOfIncome>
> </stallionlossofincome>
> </eqmquotedetailcoverage>
> </quotedetailcoverage>
> <quotedetailoptionalcoverage id="q4CAA4715E1BC44549C2D8CD0AD95EC93">
> <eqmquotedetailoptionalcoverage 
> id="e34F0B5BF1C3F4B8AA3852B76F16C8B27">
> <agreedvalue id="a3E4FC5A287FF4649859BDEEE1B356370">
> <agreedValue>0</agreedValue>
> </agreedvalue>
> <automaticextension id="aC98E54A79AA74CAFAD241E658A8EE0E6">
> <automaticExtension>0</automaticExtension>
> <autoExtentionClauseLimit/>
> </automaticextension>
> <claimingrace id="c79CD859CB52A4B73B3BC2C635A2C77FB">
> <claimingRace>0</claimingRace>
> <claimingRaceMaxLimit/>
> <claimingRaceNotify/>
> </claimingrace>
> <deductiblecoverage id="d93AB9B920CBF444091ADB2F471100263">
> <deductibleCoverage>0</deductibleCoverage>
> <dedCovDeductiblePercent/>
> <dedCovMinAggregate/>
> <dedCovFoalOver24Hours>0</dedCovFoalOver24Hours>
> <dedCovFoal24Surcharge/>
> <dedCovFoalOver7Days>0</dedCovFoalOver7Days>
> <dedCovFoal7Surcharge/>
> <dedCovMinPremPerAnimal/>
> <dedCovPolicyDeductible/>
> <dedCovPolicyAmount/>
> <dedCovManuscript/>
> <dedCovAnimal14YearsSurcharge/>
> <dedCovAnimalOver14Years>0</dedCovAnimalOver14Years>
> </deductiblecoverage>
> <doubleextension id="d729AD77AF3444030BDB465F9D37F2ED7">
> <doubleExtension>0</doubleExtension>
> </doubleextension>
> <generalendorsement id="gDC14E686221C47E99A5C9921F0474BFF">
> <generalEndorsement/>
> <generalendorsements id="g484DC902A448475D8C90154F2F755AFF">
> <generalEndorsementsTitle/>
> </generalendorsements>
> </generalendorsement>
> <manuscriptcoverage id="m204F4C1A5FCF472EB43669134255BDD1">
> <manuscriptCoverage>0</manuscriptCoverage>
> <manuscripts id="mD7CDEC55622B405EB8F83E5E70AB7C4B">
> <description/>
> <formText/>
> </manuscripts>
> </manuscriptcoverage>
> <noclaimsbonus id="nAABE3F5FE1674D25A3D5B9D954C14FFE">
> <noClaimsBonus>0</noClaimsBonus>
> <noClaimsPercent/>
> </noclaimsbonus>
> <operationsclause id="o9C55FBAC6E154626BDB92A6760DF34B9">
> <operationsClause>0</operationsClause>
> </operationsclause>
> <profitcommission id="pC762C13434294760A8338B63A3AA576D">
> <profitCommission>0</profitCommission>
> <profitCommPercent/>
> <profitCommPaidPremPercent/>
> <profitCommReturnPremPercent/>
> </profitcommission>
> <twelvemonthextension id="t27E40880947540C7BD43E09B79DAD4ED">
> <twelveMonthExtension>0</twelveMonthExtension>
> </twelvemonthextension>
> <worldwidecoverage id="w9F8A351D55DE44358CE426B1EBB951A9">
> <worldWideCoverage>0</worldWideCoverage>
> </worldwidecoverage>
> <racesurgical id="rC5A9D483CE9E42D0A5E85CD5BB8D949B">
> <raceSurgicalCoverage>0</raceSurgicalCoverage>
> <raceSurgicalCoverageCharge/>
> </racesurgical>
> </eqmquotedetailoptionalcoverage>
> </quotedetailoptionalcoverage>
> <quotedetailrisk id="q63F6803E14224075BCE85D1F36C102B4">
> <animalquotedetailrisk id="h1">
> <animalquotedetailriskcoverage id="aFADF4001DD5545EDA14DF7069431E26E">
> <ASDAmountOfInsurance/>
> <Anesthesia/>
> <Country/>
> <EuroExtension/>
> <Exclusion/>
> <ExclusionDescription/>
> <FrustrationOfExport/>
> <FrustrationOfExportAmountOfInsurance/>
> <FrustrationOfExportFrom/>
> <FrustrationOfExportTo/>
> <FrustrationOfImport/>
> <FrustrationOfImportAmountOfInsurance/>
> <FrustrationOfImportFrom/>
> <FrustrationOfImportTo/>
> <LimitedLossOfUse/>
> <LimitedLossOfUseAmountOfInsurance/>
> <LossOfUse/>
> <LossOfUseAmountOfInsurance/>
> <MajorMedical/>
> <Manuscript/>
> <ManuscriptDescription/>
> <OptionalPerils/>
> <QuoteRiskCoverageGroupID/>
> <RaceSurgical/>
> <Surgical/>
> <TheftAndUnlawfulRemoval/>
> <Transit/>
> <TripFrom/>
> <TripNumber/>
> <TripTo/>
> <WobblerSyndrome/>
> <FrustrationOfExportImport/>
> <FrustrationOfExportImportAmountOfInsurance/>
> <FrustrationOfExportImportFrom/>
> <FrustrationOfExportImportTo/>
> <RaceSurgicalPremium/>
> <ManuscriptText/>
> <MajorMedicalClaimPaidNoReturn/>
> <RaceSurgicalClaimPaidNoReturn/>
> <SurgicalClaimPaidNoReturn/>
> <ASD/>
> <frustrationofimport id="f48CC40BB20A6492F9F388CB1807155D9">
> <To/>
> <From/>
> </frustrationofimport>
> <frustrationofexport id="f03BEF88337A44ACB8EAD82A8FC11023B">
> <FrustrationofExportTo/>
> <FrustrationOfExportFrom/>
> </frustrationofexport>
> <frustrationofexportimport id="fBD54DD6011C5407F8F42537FB9071904">
> <FrustrationOfExportImportTo/>
> <FrustrationOfExportImportFrom/>
> </frustrationofexportimport>
> <transit id="t7296C0F0393846B6A411431AF2240D7B">
> <TripFrom/>
> <TripTo/>
> </transit>
> </animalquotedetailriskcoverage>
> <animalquotedetailriskdetail id="aCE211E8AB9F245FAA34587A5331D6104">
> <AnimalDomiciledElsewhere>0</AnimalDomiciledElsewhere>
> <AnimalTab/>
> <BarnName/>
> <Blank/>
> <Blank1/>
> <Blank10/>
> <Blank11/>
> <Blank12/>
> <Blank13/>
> <Blank14/>
> <Blank15/>
> <Blank16/>
> <Blank17/>
> <Blank18/>
> <Blank2/>
> <Blank3/>
> <Blank4/>
> <Blank5/>
> <Blank6/>
> <Blank7/>
> <Blank8/>
> <Blank9/>
> <CoveringStallionName/>
> <CoveringStallionStudFee/>
> <Dam/>
> <DateOfBirth>2003</DateOfBirth>
> <HealthTab/>
> <ItemNumber>1</ItemNumber>
> <LastBredDate/>
> <NameOfHorse>horse1-q1</NameOfHorse>
> <NumberOfMaresBooked/>
> <NumberOfMaresBred/>
> <NumberOfMaresInFoal/>
> <OptionalCoveragesTab/>
> <OwnershipTab/>
> <PerformanceLevel/>
> <Sire/>
> <StudFeesCharged/>
> <YearBooked/>
> <YearBred/>
> <Blank19/>
> <Blank20/>
> <Blank21/>
> <Blank22/>
> <Blank23/>
> <Blank24/>
> <Blank25/>
> <Blank26/>
> <Blank27/>
> <Blank28/>
> <Blank29/>
> <Blank30/>
> <Blank31/>
> <Blank32/>
> <StableDiscount/>
> <FoalDateOfBirth/>
> <Breed>AN</Breed>
> <MareInFoal/>
> <SecondaryUse/>
> <Sex>G</Sex>
> <Use>BR</Use>
> <ProspectiveFoalExpirationDate/>
> <StallionAvailibilityBreedingSeason/>
> <StallionLossOfIncomeBreedingSeason/>
> <StallionLossOfIncomeNumberFirstMaresBred/>
> <additionalinterests id="a5E754545BCCB466EB5ACB37ECD67E4B9">
> <Name/>
> <DBA/>
> <Address/>
> <Address2/>
> <City/>
> <Zip/>
> <Country>US</Country>
> <State/>
> <Type/>
> <AdditionalInterests>0</AdditionalInterests>
> </additionalinterests>
> <agencycommission id="a3A94F7C0702F42449167310BE501C5A3">
> <CommissionForAnimal/>
> <CommissionPercent>5</CommissionPercent>
> </agencycommission>
> <alternatepremises id="aCAEE3C9749A84E47ADE623EFA4607EC8">
> <Address1/>
> <Address2/>
> <Country>0</Country>
> <City/>
> <Zip/>
> <County>Adair</County>
> <State/>
> </alternatepremises>
> <alternatetrainer id="aEEEBD006018B4145B66B2ECA364B7C80">
> <Name/>
> <Phone/>
> </alternatetrainer>
> <amountofinsurance id="aE7CF773B26C94E1895E15888F9745226">
> <AmountOfInsuranceDesired>111</AmountOfInsuranceDesired>
> <AmountofInsurance/>
> <PartOfLargerAmount>0</PartOfLargerAmount>
> <StallionLossOfIncomeAmountOfIns/>
> <StallionCongenitalInfertilityAmountOfIns/>
> <StallionAvailabilityAmountOfIns/>
> </amountofinsurance>
> <animalcondition id="aD6C38D6974864BEDA6242A3D319CFEE6">
> <InjuryInLastYear>0</InjuryInLastYear>
> <AfflictionDescription/>
> <EyesLegFeetCondition>Yes</EyesLegFeetCondition>
> <EyesLegFeetConditionDescription/>
> </animalcondition>
> <financinginformation id="f5F0950BEAF454E6EBC43F154E2DD28E0">
> <Financed>0</Financed>
> <FinanceTerms/>
> </financinginformation>
> <health id="hEF418572057C46ACBC47DED0D5791BCA">
> <ColicOrIndigestion>0</ColicOrIndigestion>
> <HowOften/>
> <Surgical/>
> <MoreThanOne/>
> <ResectionInvolved/>
> <DateOfLastAttack/>
> <CauseOfAttack/>
> </health>
> <ownershipinformation id="oFB7E875EBF094CC7A060645F5630C420">
> <PercentageOwned/>
> <NumberOfSharesOwned/>
> <NumberOfSharesInSyndicate/>
> <SoleOwner>Yes</SoleOwner>
> </ownershipinformation>
> <purchaseinformation id="p3DF7D09F740A4AD2B366618A4C847211">
> <PurchasePrice>111</PurchasePrice>
> <PurchaseDate/>
> <HomeBredStudFee/>
> <LeaseTerms/>
> <HipNumber/>
> <SaleCompany/>
> <AmountOfCash/>
> <SpecialLeaseConditions/>
> <SpecialLeaseConditionsExplanation/>
> <TradeDescription/>
> <FoalStudFee/>
> <PurchaseType>0</PurchaseType>
> </purchaseinformation>
> <exclusions id="eA7293D93B5C7474EA845E895CB3A9D3D">
> <Allergies>0</Allergies>
> <DegenarativeJointDiseaseArthritis>0</DegenarativeJointDisease
> Arthritis>
> 
> <EPMNeurologicalDisorders>0</EPMNeurologicalDisorders>
> <FounderLaminitis>0</FounderLaminitis>
> <GastricUlcersColicGastrointestinalDisorders>0</GastricUlcersC
> olicGastro
> intestinalDisorders> 
> <HeartMurmer>0</HeartMurmer>
> <HYPPHyperkalemicPeriodicParalysis>0</HYPPHyperkalemicPeriodic
> Paralysis>
> 
> <LaryngealHemiplegia>0</LaryngealHemiplegia>
> <LymesDisease>0</LymesDisease>
> <Melanomas>0</Melanomas>
> <NavicularDisease>0</NavicularDisease>
> <Osteochandritis>0</Osteochandritis>
> <Sarcoids>0</Sarcoids>
> <WobblerNeurologicalDisorders>0</WobblerNeurologicalDisorders>
> <Other/>
> </exclusions>
> </animalquotedetailriskdetail>
> <animalquotedetailriskavailablelob
> id="a2C4025367B8849C4BBE4C60181E8A4BE">
> <EquineMortality/>
> </animalquotedetailriskavailablelob>
> <ratinganimalcoverage id="r414923BA32B7407D98DC39E00FB4CBF2">
> <ageOfAnimal/>
> <ratingasd id="rCBF146E77B264C6FABD6A916698B27FB">
> <amountOfInsurance/>
> <baseRate/>
> <calculatedResult/>
> <finalPremium/>
> <minimumAppliedPremium/>
> <netDown/>
> <premiumReturned/>
> <stableDiscount/>
> <ASD>0</ASD>
> </ratingasd>
> <rating id="r3A773416B0DB4F2D8280502AC5A63F51">
> <amountOfInsurance/>
> <baseRate/>
> <calculatedResult/>
> <finalPremium/>
> <minimumAppliedPremium/>
> <netDown/>
> <premiumReturned/>
> <stableDiscount/>
> <Anesthesia>1</Anesthesia>
> <country/>
> </rating>
> <ratingeuroextension id="rEE283A5567694742BDBCF65A38A301BD">
> <amountOfInsurance/>
> <baseRate/>
> <calculatedResult/>
> <finalPremium/>
> <minimumAppliedPremium/>
> <netDown/>
> <premiumReturned/>
> <stableDiscount/>
> <EuroExtension>0</EuroExtension>
> <country/>
> </ratingeuroextension>
> <ratingexclusion id="rF649541EC7CB4DE29A4E0FAE2D68979B">
> <amountOfInsurance/>
> <baseRate/>
> <calculatedResult/>
> <finalPremium/>
> <minimumAppliedPremium/>
> <netDown/>
> <premiumReturned/>
> <stableDiscount/>
> <Exclusion>0</Exclusion>
> <description/>
> </ratingexclusion>
> <ratingfrustrationofexport id="rD2E6B9AE341C4E1A99503D45E2944DDA">
> <amountOfInsurance/>
> <baseRate/>
> <calculatedResult/>
> <finalPremium/>
> <minimumAppliedPremium/>
> <netDown/>
> <premiumReturned/>
> <stableDiscount/>
> <FrustrationOfExport>0</FrustrationOfExport>
> <to/>
> <from/>
> <tripNumber/>
> </ratingfrustrationofexport>
> <ratingfrustrationofimport id="r1A6B2D8517904E6EAC14984F26F1A8AE">
> <amountOfInsurance/>
> <baseRate/>
> <calculatedResult/>
> <finalPremium/>
> <minimumAppliedPremium/>
> <netDown/>
> <premiumReturned/>
> <stableDiscount/>
> <FrustrationOfImport>0</FrustrationOfImport>
> <to/>
> <from/>
> <tripNumber/>
> </ratingfrustrationofimport>
> <ratinglimitedlossofuse id="rEE29CD61EC254CDDBB1A54E13118FDFB">
> <amountOfInsurance/>
> <baseRate/>
> <calculatedResult/>
> <finalPremium/>
> <minimumAppliedPremium/>
> <netDown/>
> <premiumReturned/>
> <stableDiscount/>
> <LimitedLossOfUse>0</LimitedLossOfUse>
> </ratinglimitedlossofuse>
> <ratinglossofuse id="r73F6E1309DF9451E95A004D7C6FB1C4C">
> <amountOfInsurance/>
> <baseRate/>
> <calculatedResult/>
> <finalPremium/>
> <minimumAppliedPremium/>
> <netDown/>
> <premiumReturned/>
> <stableDiscount/>
> <LossOfUse>0</LossOfUse>
> </ratinglossofuse>
> <ratingmajormedical id="rD2780262CB154AC39EF846CE0C2D142C">
> <amountOfInsurance/>
> <baseRate/>
> <calculatedResult/>
> <finalPremium/>
> <minimumAppliedPremium/>
> <netDown/>
> <premiumReturned/>
> <stableDiscount/>
> <MajorMedical>0</MajorMedical>
> <claimPaidNoReturn>0</claimPaidNoReturn>
> </ratingmajormedical>
> <ratingmanuscript id="r68BCEB6289FC46D6A8AB6B4097197929">
> <amountOfInsurance/>
> <baseRate/>
> <calculatedResult/>
> <finalPremium/>
> <minimumAppliedPremium/>
> <netDown/>
> <premiumReturned/>
> <stableDiscount/>
> <Manuscript>0</Manuscript>
> <description/>
> <text/>
> <itemNumber/>
> <itemnumber/>
> </ratingmanuscript>
> <ratingoptionalperils id="r3A0A299C845F4ED39D1B0299D991A8B1">
> <amountOfInsurance/>
> <baseRate/>
> <calculatedResult/>
> <finalPremium/>
> <minimumAppliedPremium/>
> <netDown/>
> <premiumReturned/>
> <stableDiscount/>
> <OptionalPerils/>
> </ratingoptionalperils>
> <ratingracesurgical id="r5849E720C0764CB5BD03F18C013190DF">
> <amountOfInsurance/>
> <baseRate/>
> <calculatedResult/>
> <finalPremium/>
> <minimumAppliedPremium/>
> <netDown/>
> <premiumReturned/>
> <stableDiscount/>
> <RaceSurgical>0</RaceSurgical>
> <claimPaidNoReturn>0</claimPaidNoReturn>
> </ratingracesurgical>
> <ratingsouthernhemisphereexposure
> id="rDFF792B54BA64EA79464D91048D47ACD">
> <amountOfInsurance/>
> <baseRate/>
> <calculatedResult/>
> <finalPremium/>
> <minimumAppliedPremium/>
> <netDown/>
> <premiumReturned/>
> <stableDiscount/>
> </ratingsouthernhemisphereexposure>
> <ratingsurgical id="r29C7F33612E443EB97B1794E52164FA6">
> <amountOfInsurance/>
> <baseRate/>
> <calculatedResult/>
> <finalPremium/>
> <minimumAppliedPremium/>
> <netDown/>
> <premiumReturned/>
> <stableDiscount/>
> <Surgical>0</Surgical>
> <claimPaidNoReturn>0</claimPaidNoReturn>
> </ratingsurgical>
> <ratingtheftandunlawfulremoval id="r63EC6EBDD35B4EFB84566B9E363CC262">
> <amountOfInsurance/>
> <baseRate/>
> <calculatedResult/>
> <finalPremium/>
> <minimumAppliedPremium/>
> <netDown/>
> <premiumReturned/>
> <stableDiscount/>
> <TheftAndUnlawfulRemoval>0</TheftAndUnlawfulRemoval>
> </ratingtheftandunlawfulremoval>
> <ratingtransit id="r2E417F6E8ED44CD186391119EC1F282D">
> <amountOfInsurance/>
> <baseRate/>
> <calculatedResult/>
> <finalPremium/>
> <minimumAppliedPremium/>
> <netDown/>
> <premiumReturned/>
> <stableDiscount/>
> <Transit>0</Transit>
> <to/>
> <from/>
> <tripNumber/>
> </ratingtransit>
> <ratingwobblersyndrome id="rA48ADDDD38E247DDB3D8838914E4B580">
> <amountOfInsurance/>
> <baseRate/>
> <calculatedResult/>
> <finalPremium/>
> <minimumAppliedPremium/>
> <netDown/>
> <premiumReturned/>
> <stableDiscount/>
> <WobblerSyndrome>0</WobblerSyndrome>
> </ratingwobblersyndrome>
> <ratingagreedvalue id="rB314C148347B45AC9FD820F3EE89E256">
> <amountOfInsurance/>
> <baseRate/>
> <calculatedResult/>
> <finalPremium/>
> <minimumAppliedPremium/>
> <netDown/>
> <premiumReturned/>
> <stableDiscount/>
> </ratingagreedvalue>
> <ratingautomaticextension id="rB5AB72ED761C4AE78A6575EAD20AB11F">
> <amountOfInsurance/>
> <baseRate/>
> <calculatedResult/>
> <finalPremium/>
> <minimumAppliedPremium/>
> <netDown/>
> <premiumReturned/>
> <stableDiscount/>
> <AutomaticExtension/>
> </ratingautomaticextension>
> <ratingclaimingrace id="r5F8F76B75D474C9D8F8FF08383CC2244">
> <amountOfInsurance/>
> <baseRate/>
> <calculatedResult/>
> <finalPremium/>
> <minimumAppliedPremium/>
> <netDown/>
> <premiumReturned/>
> <stableDiscount/>
> </ratingclaimingrace>
> <ratingdeductiblecoverage id="rB945249F40AF42FB9A49815DF233A3B3">
> <amountOfInsurance/>
> <baseRate/>
> <calculatedResult/>
> <finalPremium/>
> <minimumAppliedPremium/>
> <netDown/>
> <premiumReturned/>
> <stableDiscount/>
> <deductibleAverageRate/>
> <deductibleFinalRate/>
> </ratingdeductiblecoverage>
> <ratingdoubleextension id="r88AC3C67420D4120A849D788C09A613D">
> <amountOfInsurance/>
> <baseRate/>
> <calculatedResult/>
> <finalPremium/>
> <minimumAppliedPremium/>
> <netDown/>
> <premiumReturned/>
> <stableDiscount/>
> </ratingdoubleextension>
> <ratinggeneralendorsement id="r76D00FF09B2148448C2BE0F6704AB5DC">
> <amountOfInsurance/>
> <baseRate/>
> <calculatedResult/>
> <finalPremium/>
> <minimumAppliedPremium/>
> <netDown/>
> <premiumReturned/>
> <stableDiscount/>
> </ratinggeneralendorsement>
> <ratingnoclaimsbonus id="r8A599E94B5EE41A9AFB49C6111AA8060">
> <amountOfInsurance/>
> <baseRate/>
> <calculatedResult/>
> <finalPremium/>
> <minimumAppliedPremium/>
> <netDown/>
> <premiumReturned/>
> <stableDiscount/>
> </ratingnoclaimsbonus>
> <ratingoperationclause id="r6381E5EE0C024C7C9ED812500263A7D9">
> <amountOfInsurance/>
> <baseRate/>
> <calculatedResult/>
> <finalPremium/>
> <minimumAppliedPremium/>
> <netDown/>
> <premiumReturned/>
> <stableDiscount/>
> </ratingoperationclause>
> <ratingprofitcommission id="r7004B8AA1F9044B0B7161ECAA55EDD80">
> <amountOfInsurance/>
> <baseRate/>
> <calculatedResult/>
> <finalPremium/>
> <minimumAppliedPremium/>
> <netDown/>
> <premiumReturned/>
> <stableDiscount/>
> </ratingprofitcommission>
> <ratingtwelvemonthextension id="r84B6D464C044437C86DBF70D43C831AE">
> <amountOfInsurance/>
> <baseRate/>
> <calculatedResult/>
> <finalPremium/>
> <minimumAppliedPremium/>
> <netDown/>
> <premiumReturned/>
> <stableDiscount/> 
> 
> -----Original Message-----
> From: Kota, Ganesh
> Sent: Monday, November 06, 2006 11:40 AM
> To: 'xsl-list@xxxxxxxxxxxxxxxxxxxxxx'
> Subject: RE: Help needed to transform in data joining
> 
>  
> My sample test stylesheet is 
> 
> <?xml version="1.0" encoding="UTF-8"?>
> <xsl:stylesheet version="2.0"
> xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
> xmlns:envelope="http://schemas.xmlsoap.org/soap/envelope/">
>     <xsl:key name="DCHorseID"
> match="/test/results/processRequestsAsDOMResponse/result/serve
> r/response
> s/Session.getDocumentRs/session/data/equinedata/coverages/horse"
> use="@id"/>
>    <!-- <xsl:key name="DCHorseID" match="//horse" use="@id"/>-->
>     <xsl:template match="/">
>         <session>
>             <xsl:value-of select="key('DCHorseID', 'h1')"/>
>             <data>
>                 <quote>
>                     <quotedetail>
>                         <quotedetailrisk>
>                             <xsl:for-each 
> select="test/results/envelope:Envelope/envelope:Body/session/d
> ata/quote/
> quotedetail/quotedetailrisk/animalquotedetailrisk">
> <xsl:variable name="UIHorseID">
>                                         <xsl:value-of select="@id"/>
>                                     </xsl:variable>
>                                 <animalquotedetailrisk>
>                                     <horse><xsl:value-of 
> select="$UIHorseID"/></horse> 
>                                     <ratinganimalcoverage>
>                                         <xsl:attribute name="id">
>                                             <xsl:value-of 
> select="ratinganimalcoverage/@id">
>                                             </xsl:value-of>
>                                         </xsl:attribute>
>                                         <ratingasd>
>                                             <xsl:attribute name="id">
>                                                 <xsl:value-of 
> select="ratinganimalcoverage/ratingasd/@id">
>                                                 </xsl:value-of>
>                                             </xsl:attribute>
>                                             <baseRate>
> 			<xsl:value-of select="key('DCHorseID', 
> $UIHorseID)/HorsePrivateASnDRate"/>
>                                             </baseRate>
>                                         </ratingasd>
>                                     </ratinganimalcoverage>
>                                 </animalquotedetailrisk>
>                             </xsl:for-each>
>                         </quotedetailrisk>
>                     </quotedetail>
>                 </quote>
>             </data>
>         </session>
>     </xsl:template>
> </xsl:stylesheet>
> 
> It's not retrieving the value from the key of  DCHorseID.I 
> will appreciate if you point me here.
> 
> Thanks,
> Ganesh 
> 
> -----Original Message-----
> From: Kota, Ganesh
> Sent: Monday, November 06, 2006 9:41 AM
> To: 'xsl-list@xxxxxxxxxxxxxxxxxxxxxx'
> Subject: RE: Help needed to transform in data joining
> 
> Thanks guys for your transformations. These transformations 
> helped me up to some extent but It's not fully done.
> 
> 1) Address child element data needs to be copied only if 
> child element data of SBSaddress_ element doesn't exist.
> 
> 2) This template driven approach may not work for my 
> transformation as my source XML document has 2000 elements in 
> it. I need to do with fill in the blanks design pattern with 
> out using templates.
> 
> 3) Does xsl:key help me to do this ?
> 
> Thanks again for your help,
> Kota
> 
> -----Original Message-----
> From: Kota, Ganesh
> Sent: Thursday, November 02, 2006 10:19 AM
> To: 'xsl-list@xxxxxxxxxxxxxxxxxxxxxx'
> Subject: Help needed to transform in data joining
> 
> Hi,
> I have this XML file , need to do union of all Address and 
> SBSaddress_ elements based on id attribute join condition in 
> XSL file .Address element has to be overridden in the output 
> if SBSaddress has the data.
> I appreciate if anybody can help and give some references on this.
> Thanks,
> Kota
> 
> Input XML file:
> 
> <root>
> <A>
> <B>
> <ADDRESSES>
> <ADDRESS
> id='1'><State>CO</State><Address1/><Address2/><City>flroen</Ci
> ty><Countr
> y>UnitedStates</Country><Province>--Select--</Province><ZipCod
> e>11</ZipC
> ode><County/></ADDRESS>
> <ADDRESS
> id='2'><State>KY</State><Address1>campbellcounty</Address1><Ad
> dress2/><C
> ity>fortthomas</City><Country>UnitedStates</Country><Province>
> --Select--
> </Province><ZipCode>41075</ZipCode><County/></ADDRESS>
> </ADDRESSES>
> </B>
> </A>
> <c>
> <addresslists>
> <SBSaddress_
> id='1'><State>CO</State><Address1>florence</Address1><Address2
> /><City>fl
> roen</City><Country>UnitedStates</Country><Province>--Select--
> </Province
> ><ZipCode>11</ZipCode><County/></SBSaddress_>
> <SBSaddress_
> id='2'><State></State><Address1></Address1><Address2>bananacou
> nty</<Addr
> ess2><City>fortthomas</City><Country>UnitedStates</Country><Pr
> ovince>--S
> elect--</Province><ZipCode>11</ZipCode><County/></SBSaddress_>
> </addresslists>
> </c>
> </root>
> 
> **************************************************************
> **********************
> The content of this e-mail message and any attachments are 
> confidential and may be legally privileged, intended solely 
> for the addressee. If you are not the intended recipient, be 
> advised that any use, dissemination, distribution, or copying 
> of this e-mail is strictly prohibited.  If you receive this 
> message in error, please notify the sender immediately by 
> reply email and destroy the message and its attachments.
> **************************************************************
> **********************