Hello all,
Talking about Excel 2007 on Windows 7.
Here is the deal:
Let's say I have two xml docs, that, if opened in excel, and opened as an XML table would like like this:
#1 Case Info: here's a link to the file- it just needs to become a sheet- no transformation needed.
https://my.syncplicity.com/share/cx2wsytjy4/Case_Info.xml
And the 2nd looks like this:
link to it: https://my.syncplicity.com/share/fzzxthhqwo/Voting_Info.xml
Let's call the first one Case info, and the second one Vote Info.
Case info and Vote info need to go into one Excel sheet, with two sheets called " case info and vote info"
Case info just needs to go into a sheet.
Vote info needs to undergo a transformation that is sort of a logic puzzle. Here's a link to before: I've included it for you to see as an xml and xlsx. Perhaps someone versed in xml can just use the xml file to push a xlsx that's ready to go.
What Vote Info.xml looks like when you just open in Excel:
And what Vote info needs to look like:
link: https://my.syncplicity.com/share/vnowsbqtiu/correct_votings_xlsx.xlsx
So, what exactly is the transformation? If you can't tell, this is a listing of legal cases, judge names, and how they voted. The judge's name needs to go down the first column, and only be there 1 time. Then the cases need to go across the first row, again, only expressed 1 time. Then the votes fill in accordingly.
Note, the "final version" example doesn't actually have the right votes in the right place, but I think you get the idea.
Now, that's the idea of the concept. I need a batch process because I have 5,000 files: 2500 case info xml and 2500 voting xml. I need 2500 combined case info and voting xlsx workbooks.
Let's keep discussion in the thread, but of course feel free to PM me.
dguenther
Talking about Excel 2007 on Windows 7.
Here is the deal:
Let's say I have two xml docs, that, if opened in excel, and opened as an XML table would like like this:
#1 Case Info: here's a link to the file- it just needs to become a sheet- no transformation needed.
https://my.syncplicity.com/share/cx2wsytjy4/Case_Info.xml
And the 2nd looks like this:
link to it: https://my.syncplicity.com/share/fzzxthhqwo/Voting_Info.xml
Let's call the first one Case info, and the second one Vote Info.
Case info and Vote info need to go into one Excel sheet, with two sheets called " case info and vote info"
Case info just needs to go into a sheet.
Vote info needs to undergo a transformation that is sort of a logic puzzle. Here's a link to before: I've included it for you to see as an xml and xlsx. Perhaps someone versed in xml can just use the xml file to push a xlsx that's ready to go.
What Vote Info.xml looks like when you just open in Excel:
And what Vote info needs to look like:
link: https://my.syncplicity.com/share/vnowsbqtiu/correct_votings_xlsx.xlsx
So, what exactly is the transformation? If you can't tell, this is a listing of legal cases, judge names, and how they voted. The judge's name needs to go down the first column, and only be there 1 time. Then the cases need to go across the first row, again, only expressed 1 time. Then the votes fill in accordingly.
Note, the "final version" example doesn't actually have the right votes in the right place, but I think you get the idea.
Now, that's the idea of the concept. I need a batch process because I have 5,000 files: 2500 case info xml and 2500 voting xml. I need 2500 combined case info and voting xlsx workbooks.
Let's keep discussion in the thread, but of course feel free to PM me.
dguenther
