0 Replies Latest reply: Mar 24, 2013 2:48 PM by 987927 RSS

    Displaying only the distinct rows in Xml

    987927
      Hi All

      I am using Documaker 11.5 version...

      I have a scenario like...

      My Xml is as shown below....

      <DepreciationDtl>
      <Depreciation>
      <Year>1<\Year>
      <Percentage>5<\Percentage>
      </Depreciation>
      <Depreciation>
      <Year>2<\Year>
      <Percentage>5<\Percentage>
      </Depreciation>
      <Depreciation>
      <Year>3<\Year>
      <Percentage>5<\Percentage>
      </Depreciation>
      <Depreciation>
      <Year>4<\Year>
      <Percentage>5<\Percentage>
      </Depreciation>
      <Depreciation>
      <Year>5<\Year>
      <Percentage>20<\Percentage>
      </Depreciation>
      <Depreciation>
      <Year>6<\Year>
      <Percentage>20<\Percentage>
      </Depreciation>
      <Depreciation>
      <Year>7<\Year>
      <Percentage>20<\Percentage>
      </Depreciation>
      <Depreciation>
      <Year>8<\Year>
      <Percentage>20<\Percentage>
      </Depreciation>
      <Depreciation>
      <Year>9<\Year>
      <Percentage>20<\Percentage>
      </Depreciation>
      <Depreciation>
      <Year>10<\Year>
      <Percentage>30<\Percentage>
      </Depreciation>
      <Depreciation>
      <Year>11<\Year>
      <Percentage>30<\Percentage>
      </Depreciation>
      <Depreciation>
      <Year>12<\Year>
      <Percentage>30<\Percentage>
      </Depreciation>
      <Depreciation>
      <Year>13<\Year>
      <Percentage>40<\Percentage>
      </Depreciation>
      <Depreciation>
      <Year>14<\Year>
      <Percentage>40<\Percentage>
      </Depreciation>
      <Depreciation>
      <Year>15<\Year>
      <Percentage>40<\Percentage>
      </Depreciation>
      </DepreciationDtl>

      Instead of showing all the values in a table...I need to show only the distinct values based upon Percentage...
      i.e. i need display only 4 rows in my table instead of 15....

      Please help me in achieving this....

      Thanks in advance....