topic Re: how to remove synthetic keys from XML file generated script in QlikView

how to remove synthetic keys from XML file generated script

Fri, 05 Jun 2015 19:10:33 GMT

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

Re: how to remove synthetic keys from XML file generated script

Clever_Anjos — Fri, 05 Jun 2015 20:17:07 GMT

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

Please read this article: Synthetic Keys

Re: how to remove synthetic keys from XML file generated script

Fri, 05 Jun 2015 20:30:20 GMT

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.

Re: how to remove synthetic keys from XML file generated script

Clever_Anjos — Fri, 05 Jun 2015 20:34:25 GMT

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

Re: how to remove synthetic keys from XML file generated script

Fri, 05 Jun 2015 20:36:35 GMT

Thanks! I will start with that