|
|
 top
|
  Subject: XSLT - XPATH - MATRIX?
Author: John Pham
Date: 09 Mar 2007 07:00 PM
Originally Posted: 09 Mar 2007 06:54 PM
|
Hi,
I have one xml file that contained tree tables. Please see the attached .xml and .xsl files.
Table_A: RowID, ID, ColID, and Data
Table_B: ID, and Index_B
Table_C: Name, ID, and Index_C
I would like to write a stylesheet (.xsl) that display the result in a matrix with these conditions below:
1. Display the Name in Table_C
2. Check the Table_C/ID = Table_A/RowID
3. If yes, get/check the Table_A/ColID = Table_B/ID
4. If yes, get the index() in Table_B
5. Display the value of the Data in Table_A base on the position of the index() in Table_B.
Note: I could have more that one Table_A/RowID with the same value but the Table_A/ColID must be difference. Is there a way to display the matrix without hard code the value for each RowID, ColID, and ID?
Below is a sample of the matrix output (Please ignore the ---)
Name---0---1---2---3---4---5---6
AAA----YY------YY------YY---YY
BBB----YY
CCC--------Y
DDD-------------Y
EEE-----------------YYY
FFF---------------------YYY
GGG-----------------------------YYY
Thanks in advance.
-John
 matrix.xsl
XSL file
 matrix.xml
XML file
|
|
|
|
