Add certain value from one complex type to another via common key value

[Former Member]

Hi

Let's say I have a web service which has several table structured value as output

doc

-docid

-type

url

-docid

-url

the common key is docid, which will be unique within both, doc and url node but allows to connect these two nodes (url node holds the url for a certain docid)

I now would like to merge these two nodes in order to display everythig in one single table view. Is this possible?

doc node:

docid | type

-

---

1 | pdf

2 | pdf

url node:

-

---

docid | url

1 | http://www.google.com/doc1.pdf

2 | http://www.google.com/doc2.pdf

target state table view:

docid | type | url

-

---

1 | pdf | http://www.google.com/doc1.pdf

2 | pdf | http://www.google.com/doc2.pdf

Might be Union the right element? I only managed to display one row with it.....

Edited by: Jan Nyfeler on Apr 16, 2010 3:14 PM

[Former Member · Accepted solution]

If this is for 7.2 still correct, the solution seems to be as there is no solution except handle it in the service itself