how to remove synthetic keys from XML file generated script

[#1]

I need a primer on how best to parse XML files. By default Qlikview is generating so many synthetic keys the file won't load

[Clever_Anjos]

The strategies for removing Synthetic Keys are the same no matter what source you use.

Please read this article: Synthetic Keys

[#3]

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.

[Clever_Anjos]

You could

QUALIFY *;

at very start of your script, Qlikview will load all tables apart, so you can analyse the model unqualify fields that have to be keys

[#5]

Thanks! I will start with that