xsl-list
[Top] [All Lists]

RE: [xsl] RE: Help needed to transform in data joining

2006-11-07 01:35:55
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(_at_)GAIC(_dot_)COM] 
Sent: 06 November 2006 22:58
To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
Subject: [xsl] 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(_at_)lists(_dot_)mulberrytech(_dot_)com'
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(_at_)lists(_dot_)mulberrytech(_dot_)com'
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(_at_)lists(_dot_)mulberrytech(_dot_)com'
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.
**************************************************************
**********************

--~------------------------------------------------------------------
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>
--~--



--~------------------------------------------------------------------
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>
--~--