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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|