How do I get rid of #agg fields when Importing an XML file into E.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm importing an XML file that has int and double information within it. When
the data is imported into Excel I get an extra column tagged with #agg

For example:

- <NewDataSet>
- <Results>
<FOO>41.01</FOO>
</Results>

This creates two columns when importing to Excel
/Results/FOO /Results/FOO/#agg
41.01 41.01
 
Back
Top