Re: how to remove synthetic keys from XML file generated script
Thanks. And I understand the pros and cons of synthetic keys. I'm trying to address a major con which is the unintended generation of many thousands synthetic keys I don't want.
I'm using the script that the web file import generated. It created 22 tables based on the xml items themselves with a large number of synthetic keys between them. I don't even know how many because Qlikview eats up all my memory to the point where I have to shut down windows by turning off the power. ( I can't even run task manager. )
I'm thinking I'm going about this the wrong way, I need to generate the hierarchical relationships into relational as it's reading the items/values because there is no "key" in the XML to provide a normal join, it's just an item under an item within the XML.
I think that's what I need to do but am at a loss how to go about that in script.