I have an extremely dense XML file with 116 columns and 700+ rows on average, sometimes more sometimes less. Currently the only way we have of handling this XML file is to import it into Excel, delete the unneeded columns and rows and then manipulate the data from there.
What I'm looking for is a better way of doing this, ideally I just want to bring in 10 columns (each is defined by name) and ignore the rest of excess data. Is there a way to do this either a program or coding-wise? I took a quick look at XSLT but I'm not sure where to start.
Here is the sample file Click Here
I only need the following fields,
ns1:ActivityNumber2 ns1:Status ns1:ActivityDate ns1:TypeCodeName ns1:LandId3 ns1:ServiceClientName ns1:ActivityNumber6 ns1:ClientName8 ns1:LtoPlanNumber
ns1:ActivityNumber6 ns1:ClientName8 may occasionally be named 7 and 9 respectively for some unknown reason