implement in XSLT

scubin · November 17th, 2009, 12:58 AM

Hi ,

Can someone help me to implement this logic in xslt

I have an incoming xml from which i need to display output xml according to the input xml indicators
Following is the condition table according to which i need to display the output in runtime
Ind ColorInd code1 code2 code3
0 NA TA 10 15
99 NA TA ED 15
1 (N=0 or more) TB 10 15
1 (R>=1 and N>=0)
TB N5 AB
1 (Y=1 and N>=0) TB O2 15
1 (R>=1,Y>=1 N>=0) TB OG AB
1 (Y>1 and N>=0) TB OG 15

Where In input xml When colorInd=0 it is N
=1 it is Y
=2 it is R

InputXML

<Users>

<User>

<Color>

<Ind>1</Ind>
<ColorInd>1</ColorInd>

</color>
<Color>

<Ind>1</Ind>
<ColorInd>2</ColorInd>

</color>
.....
</User>
</Users>

OutputXML:

<Color>

<Code1>TB</Code1>
<Code2>N5</Code2>
<Code3>15</Code2>
<Color/>

I need to display the code1,code2,code3 dynamicaly based on the input xml
For example if (R>=1 and N>=0) i.e when R occurs one or more times and N occurs 0 or more times in input xml . i need to display TB N5 AB

Thanks in advance

scubin · November 17th, 2009, 01:10 AM

Code:

Ind                 ColorInd                              code1    code2    code3
0                   NA                                       TA       10        15
99                  NA                                      TA        ED         15
1                    (N=0 or more)                         TB         10          15
1                          (R>=1 and N>=0)               TB        N5         AB
1                        (Y=1  and N>=0)                   TB         O2         15
1                                 (R>=1,Y>=1 N>=0)          TB       OG        AB
1                                        (Y>1 and N>=0)     TB        OG        15

mhkay · November 17th, 2009, 06:18 AM

Looks to me as if you could translate your decision table directly into a set of template rules, one for each row of the table. For example, the fourth row might become

Code:

<xsl:template match="Color[Ind='1' and ColorInd='2']">
  <Color>
        <Code1>TB</Code1>
        <Code2>N5</Code2>
        <Code3>AB</Code2>
   </Color>
</xsl:template>

However, I haven't understood the RNY part of your problem description, I don't understand the mapping from ColorInd to RNY values.

scubin · November 17th, 2009, 09:10 AM

Thanks kay,the above proposed solution doesnt work for me.sorry for not being clear.I will try to explain again

R,N,Y values are determined from the input XML by the value of colorInd.

when colorInd=0 It is N
=1 It is Y
=2 It is R

And in decision table in ColorInd column where you see (Eg: R>=1,N>=0,Y=1 and N>=0) are all different conditions to display those code1,code2,code3 values.

so in order to validate those different coditions and display dynamically according to those conditions first i need to determine the count of R's count of N's and count of Y's in the input XML.If the Ind=1 ,Once i determine the occurences of these RNY values i need to apply the different conditions and display corresponding values

For example if (R>=1 and N>=0) i.e when R occurs one or more times and N occurs 0 or more times in input xml . i need to display TB N5 AB

Input XML

Code:

<Users>

<User>
<Ind>1</Ind>

<Color>
..
<ColorInd>1</ColorInd>

</Color> 
<Color>
..
<ColorInd>2</ColorInd>

</Color> 
.....
<!-- Color node can occur n times-->
</User>
</Users>

sorry i posted the wrong xml in my previous post "placed Ind at wrong level"

so If Ind is "0" or "99" i can directly display corresponding code1,2,3 values and need not to verify any conditions

Let me know if iam not clear.

Thanks a lot

mhkay · November 17th, 2009, 09:52 AM

So, it seems that by R>=1 you actually mean

[code]
count(//ColorInd[.=0]) >= 1
[code]

So your logic becomes

Code:

<xsl:choose>
  <xsl:when test="Ind=0">
    ...
  </
  <xsl:when test="Ind=1">
      <xsl:choose>
           <xsl:when test="count(//ColorInd[.=2]) >= 1 and count(//ColorInd[.=0]) >= 0">
               <color>
                   <code1>TB</code1>
                   <code2>10</code2>
                   <code3>15</code3>
                </color>
           </xsl:when>
           <xsl:when test="count(//ColorInd[.=0]) >= 1">
               <color>
                   <code1>TB</code1>
                   <code2>10</code2>
                   <code3>15</code3>
                </color>
           </xsl:when>

etc.

scubin · November 18th, 2009, 01:44 AM

Thanks a lot Kay,that helped me