Displaying Descriptions Based on Codes

Play the video

Subject: Displaying Descriptions Based on Codes
From: "Katie McNally" <kmcnally9@xxxxxxxxxxx>
Date: Thu, 14 Mar 2002 17:33:19 -0600

The XML that I get back after posting to a vendor contains data for a set of transactions. I am displaying each transaction as a row in a table. One of the columns needs to show the Transaction Description. This value is not part of the XML data returned. Instead, for each transaction, a code (Nm=CODE") is returned. The numeric value for the tag is the code, and is associated to a description. Right now we have a spreadsheet of what all the codes and there corresponding descriptions are.

How do I display the description for each transaction using XSL when the xml contains only the code?

Here is an example of what the XML I get back looks like:

<Result>
<TransSet>
<Transaction Index="1">
<Tg Nm="INTEREST_RT">7.345</Tg>
<Tg Nm="PRINCIPAL">100000.00</Tg>
<Tg Nm="BALANCE">20000.00</Tg>
<Tg Nm="CODE">13</Tg>
</Transaction>
<Transaction Index="2">
<Tg Nm="INTEREST_RT">7.045</Tg>
<Tg Nm="PRINCIPAL">200000.00</Tg>
<Tg Nm="BALANCE">70000.00</Tg>
<Tg Nm="CODE">45</Tg>
</Transaction>
<Transaction Index="3">
<Tg Nm="INTEREST_RT">6.945</Tg>
<Tg Nm="PRINCIPAL">150000.00</Tg>
<Tg Nm="BALANCE">10000.00</Tg>
<Tg Nm="CODE">17</Tg>
</Transaction>
...
</TransSet>
</Result>

Below is an example of the Codes and their Descriptions:

Code - Description

1 - Escrow Advance
2 - Escrow Deposit
...
13 - Fee Transaction
...
17 - Payment
...
45 - Adjustment

Thanks, Katie


_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com

XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list

Current Thread
Displaying Descriptions Based on Codes Katie McNally - Thu, 14 Mar 2002 18:29:42 -0500 (EST) <= Carsten Klein - Thu, 14 Mar 2002 19:01:47 -0500 (EST) Thomas B. Passin - Fri, 15 Mar 2002 11:18:32 -0500 (EST)

<- Previous	Index	Next ->
Re: Process an element depend, Peter Davis	Thread	Re: Displaying Descriptions B, Carsten Klein
RE: IF-Test.....continued, Wendell Piez	Date	Re: Displaying Descriptions B, Carsten Klein
	Month

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Subscribe in XML format

RSS 2.0
Atom 0.3

XML Editor - Download a 15 Day Free Trial Now >

See What's New in Stylus Studio >

Buy Stylus Studio - XML Editor - Now >