Distinct row in XMII

[Former Member]

Can any body tell me how to get distinct row(not distinct value) from a xml document without using calculated column ?

Is there any stylesheet available which will allow us to extract distinct row from a xml document

[jcgood25]

What makes the Row distinct?

[Former Member]

All the columns together make a row distinct

r\c c1 c2 c3

1 1 2 A

2 1 2 A

3 3 4 B

This table has 3 rows and 3 cols.

so the distinct rows are

1 2 A

3 4 B

[Former Member]

sometimes you just have to get you're hands dirty and write something...

[Former Member]

Sajjad

To say frankly, there is no single xMII-defined action to get distinct rows from an XML File in BLS.

Instead, you may try with a number of actions (Repeater, Conditional etc) to loop the XML file, then check whether or not each column values one by one in previous row are matched with each accordingly column values one by one in next row while looping, then append rows to the XML Output Document depeding on satisfaction of mismatched two successive rows.

Regards

Som

[Former Member]

Try google. You may be able to use XSL transformation to get the result. With a quick search on 'xslt distinct values' I got the following. May be this will help you.

http://www.eggheadcafe.com/articles/20010508.asp

John