topic Re: XML Keys in QlikView

XML Keys

lmonincx — Thu, 23 Apr 2009 16:03:16 GMT

Hi,

This is my first time working with xml files,I am loading several xml files in my application, they are being concatenated but there is no key which links the different tables together.QV generates a %key but that is always a 0 for eachfile, how can i create/get a key to link the files?

any help is appreciated.

XML Keys

Thu, 23 Apr 2009 20:20:38 GMT

When you are loading data into an application, fields with like names are joined.

If your fields are do not have the same name, you can use an alias to make the names match.

SELECT Field1, Field1 AS QKey

Sometimes it helps to load a field with its given name and then load it again with the alias to make it a key.

Once both fields have the same name, QlikView will link them. You can use the Table Viewer (Ctrl+T) to see a visual respresentation of your data.

XML Keys

rwunderlich — Fri, 24 Apr 2009 01:49:29 GMT

When loading multple xml files like *.xml, you have to create some file-based uniqueness for the key. Check out this post from the archives to see if it solves your problem.
http://community.qlik.com/forums/p/13883/54380.aspx#54380

-Rob

XML Keys

Fri, 11 Feb 2011 00:46:35 GMT

Resource not found when clicking thta URL. Would it be possible to correc the URL?

XML Keys

rwunderlich — Sat, 12 Feb 2011 07:05:53 GMT

The link works for me but I understand it doesn't work for you. Here's the content at that link:

"The problem is with the generated %Key... field, which is a generated counter starting with 0 that links the child xml node with the parent node. The xml load process resets this counter to zero at the beginning of each file so child elements from the second file are incorrectly linked to parents from a previous file. The solution is to introduce some uniqueness into the key so you get linkage only within an individual file. Modify your %Key... statements as follows:

FileBaseName() & %Key_devices_DAEC5B79D00913EA as Key //key created by wizard

That will create unique keys and your data should link up correctly

. -Rob"

If that doesn't resolve your question, post some details of your specific problem here and I'll try to respond.

Re: XML Keys

Tyler_Waterfall — Wed, 05 Nov 2014 21:59:20 GMT

Still helpful, 3 years later. Thanks Rob Wunderlich!

Re: XML Keys

rwunderlich — Thu, 06 Nov 2014 16:02:31 GMT

Glad to know the archives are still useful!

-Rob

Re: XML Keys

ingoniclas — Fri, 01 Mar 2019 15:37:40 GMT

Another 5 years this also saved my life. Awesome, Rob!

Re: XML Keys

Arek92 — Fri, 19 Apr 2024 09:08:10 GMT

13 years later and it still works like a charm. Thanks, Rob!