Is there a free XML viewer to do "pivot tables"
- by FumbleFingers
I have an *.xml file on a PC running Windows XP, with a structure something like...
<movies id="my movies"
<movie name="Unforgiven"
<people star="Clint Eastwood" director="Clint Eastwood"/>
</movie>
<movie name="A Fistful of Dollars"
<people star="Clint Eastwood" director="Sergio Leone"/>
</movie>
<movie name="J Edgar"
<people star="Leonardo DiCaprio" director="Clint Eastwood"/>
</movie>
</movies>
I want to open this file in a viewer utility which will show one line per movie, filtered by a condition such as director="Clint Eastwood", including the relevant value for movie name on each line.
Note - that's just an example. My actual file has thousands of lines, each possibly several hundred bytes long, and there are many more levels and named values. The important thing is I want to apply a filter for a specified value of some field at some level. And I want to see one line for every case where that value occurs, showing the values for any fields I specify, even if they're stored at higher levels.
I may be mistaken in saying what I want is a "pivot table" - I don't know what I should call it.