Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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
Resource not found when clicking thta URL. Would it be possible to correc the URL?
The link works for me but I understand it doesn't work for you. Here's the content at that link:
Still helpful, 3 years later. Thanks Rob Wunderlich!
Glad to know the archives are still useful!
-Rob
Another 5 years this also saved my life. Awesome, Rob!
13 years later and it still works like a charm. Thanks, Rob!