XSLT duplicating dependent data from XML

62 Views Asked by At

I am facing issue with the xslt transformation from xml.

Xml: The node "<wd:GPAR_LRV_Dependents_group>" is repeated 12 times in xml and the business object to extract dependent information is "worker". So for every report entry it is repeated.

enter image description here

Xslt: I have used "for-each" and that's the reason data is duplicated

enter image description here

Output: This is how the output looks, the data is duplicated. Ideally dependent one, two and three should populate only once.

enter image description here

How can I restrict the data from duplicating? how can I do that in Xslt?

Any suggestion how to get this or manage this via calc field?

Thanks!

I have tried for-each-group with dependent ID and I tried position(), but that did not solve it.

1

There are 1 best solutions below

0
On

We can't see the rest of your XSLT or XML, so we can't see if you are doing anything to output the record multiple times.

You should be able to filter down to Dependent Events and Successfully Completed by adding a filter on the secondary business object.

If you update your pictures to include everything, you may get more specific help.

-Wyatt