A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Denormalized data in Excel



 
 
Thread Tools Display Modes
  #1  
Old December 23rd, 2009, 12:42 PM posted to microsoft.public.excel.misc
Jabez Gan [MVP]
external usenet poster
 
Posts: 3
Default Denormalized data in Excel

Hi,

I'm not an expert in Excel, but I opened an XML file in Excel, and modified
and now I'm trying to export it out. However it is telling me that:

____ is not exportable because it contains the following:
Denormalized data

I do not understand what the above is telling me.

A sample XML file can be found in the below link:
http://muaddib-images.com/sample_xml.xml

Can someone give me a quick guide on what's wrong?

On Excel 2007 here.

Thanks!

  #2  
Old December 23rd, 2009, 02:35 PM posted to microsoft.public.excel.misc
Dave O
external usenet poster
 
Posts: 408
Default Denormalized data in Excel

In a database, "normalized" data has been associated with data
identifiers that are used to link it to other database records. For
instance, if you had an account with an online retailer, they would
link your account number (an identifier unique to you) to your name /
address / phone data, and link the account number with your purchases.
So if you bought an item that later was recalled for some reason, they
could write a query that creates a name and address list of all the
people that bought that item.

I am not familiar with XML, but it sounds like you modified the data
in such a way that unique identifiers were dis-associated from their
data records. You *may* be able to work arouund this by saving the
file in an Excel format rather than in an XML format; or you might
save the file in comma separated value (CSV) format and re-import it
into Excel.

Good luck with it! Happy ChrismaHonnaKwanzaaka!

Dave O
Eschew obfuscation
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:17 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.