Unique Record count
Please help me to resolve the following issue.
I have got a XML file. The structure is as follows.
<Claim>
<Template>
<Documents>
</Documents>
</Template>
</Claim>
In the parent, I have Claim Number.
In the Child, I have Template Name
In the Grand Child, I have Document Name, Verified
Now, what I want is to show all the Documents which is not verified with the parent Claim Number, and count unique Claim Number.
Expected Result:
Claim Number Document Name Verified
********************************************************
1 D1 N
1 D2 N
2 D1 N
3 D4 N
4 D4 N
4 D5 N
Total Unique Claim(s): 4
Original XML structure: