October 29, 2014 at 8:52 am
got a pain of an xml file to load. The xsd file generated through a bit of 'googling' has caused some interesting issues.
It appears all 30 data items are tagged as <data>
so when this is loaded in we get one column rather than 30 columns. Is there another way of doing this? or a neat trick to pivot them into 30 columns.
It may be I need to put all the data into SQL and wave a magic wand
Any help or hints appreciated
E
October 29, 2014 at 9:10 am
Can you post a small sample of your data?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
October 29, 2014 at 10:16 am
the XSD has just one data column in it. This is the real crux of the issue. So when I extract the data I get text and cell_id that I can .
The XML looks like:
<Table ss:FullColumns="1" ss:FullRows="1">
<Row>
<Cell>
<Data ss:Type="String">ColumnA</Data>
</Cell>
<Cell>
<Data ss:Type="String">ColumnB</Data>
</Cell>
</Row>
The problem is that when opening in excel you see a normal table with multiple columns and rows. When this comes through the XML Source it just treats the column data the same so as an example 20 rows of 20 columns in Excel , yet when I import the XML I just get one column with 400 different values!
hope that helps
E
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply