I'm new to XSLT and I'm still learning. I currently face an issue where I need to combine nodes with the same ID. The nodes with the same ID will have different values and these values need to be combined as well.
Below is my initial sample XML:
<OBR>
<row>
<ID>T084</ID>
<col2>Y</col2>
<col3></col3>
<col4></col4>
</row>
<row>
<ID>T084</ID>
<col2></col2>
<col3>Y</col3>
<col4></col4>
</row>
<row>
<ID>123456</ID>
<col2></col2>
<col3>Y</col3>
<col4></col4>
</row>
</OBR>
Given I need to populate empty values with "N" my desired output would be:
<OBR>
<row>
<ID>T084</ID>
<col2>Y</col2>
<col3>Y</col3>
<col4>N</col4>
</row>
<row>
<ID>125659</ID>
<col2>N</col2>
<col3>Y</col3>
<col4>N</col4>
</row>
</OBR>
Can anyone point me in the right direction? Thank you in advance.