Assuming "reatilstoreids.xml" has the form:

<stores>
  <store id="2345">Bangalore central</store>
  <store id="4567">Walmart</store>
</stores>

Then:

<xsl:variable 
  name="store-name"
  select="RetailStoreID"/>

<xsl:value-of 
  select="document('reatilstoreids.xml')/stores/store[descendant-or-self::* = $store-name]/@id"/>

Should return the value of "id".


Bharat Shetty <bharat.shetty@xxxxxxxxx> writes:

> Hi all,
>
> I am glad I came across this group. 
>
> I need to transform a XML to other structure XML using XSLT.
>
> Fine I have done that quite well according to my projects needs.
>
> Now the problem is ....
>
> When an input element of tag
>
> <RetailStoreID>Bangalore Central</RetailStoreID> is encountered in the
> input XML ( Please note that At this stage since this XML is genreated
> from some transaction handling code, I will not know in advance what
> store will appear in that tag . But eventually all of them are assumed
> to be in some lookup table that i will explain now ) , my XSLT should
> be able to refer to some other XML that stores in this format
>
> Retail Store Name                      ID
> ===========================
> Bangalore central                  2345
> Walmart                               4567
>
> like that ....
>
> I tried using the document("reatilstoreids.xml") what to put in the
> query after this is beating me ...
>
> When Walmart is encountered i need to get 4567 and if Bangalore
> central i shud get 2345 through some testing so that thats is
> displayed in the Output XML . Just help me on how to get ids of the
> names encountered in the input XML in this other XML called
> RetailerStoreIDs.xml
>
>
> TIA