Question Re: Distinct row in XMII in Product Lifecycle Management Q&A

Distinct row in XMII

Former Member — Tue, 11 Sep 2007 17:43:07 GMT

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

Re: Distinct row in XMII

jcgood25 — Tue, 11 Sep 2007 18:33:32 GMT

What makes the Row distinct?

Re: Distinct row in XMII

Former Member — Tue, 11 Sep 2007 18:38:54 GMT

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

Re: Distinct row in XMII

Former Member — Tue, 11 Sep 2007 20:38:58 GMT

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

Re: Distinct row in XMII

Former Member — Wed, 12 Sep 2007 08:53:57 GMT

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

Re: Distinct row in XMII

Former Member — Wed, 12 Sep 2007 14:23:59 GMT

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