topic Re: Problem loading XMLs in QlikView

Problem loading XMLs

Fri, 16 Oct 2015 21:15:42 GMT

Hi all,

I want to load different XML files, they have the same format , so I want to have all their data in the same tables (I've attached the script).

In the script, I load an inline table with part of the path, because all files are in different folders, and with that way I have a shorter script.

I want to clarify that before that, I had loaded all the files individually and the %key generated by the wizard was the same for all them.

The problem is that the %key is repeated when the script loads all the files, leaving false associations.

What can I do??

Thanks in advance!

Sat, 17 Oct 2015 22:49:08 GMT

Hi, please don't use Qlikview generated Key columns as your associated keys. Please use your data points in the XML to make correct associations.

rwunderlich — Sun, 18 Oct 2015 10:51:19 GMT

The trick is to add some uniqueness to the key, like the $(folder) or FilePath():

FilePath() & %Key_destino_2C4D9A0B3E130196 as key_ejecucion_SINC

-Rob

Mon, 19 Oct 2015 13:17:44 GMT

Thank you very much Rob!! It works!

Have a good week.

Mon, 19 Oct 2015 13:28:36 GMT

Thanks for your answer. My problem was that some XML nodes didn't have data points.

Have a good week!

daniel_sonda — Mon, 12 Sep 2016 18:15:01 GMT

What's the logic behind the field [%Key_destino_2C4D9A0B3E130196]?

Is a sequencial key based on [destino] field?

rwunderlich — Fri, 30 Sep 2016 02:00:15 GMT

The [%Key_destino_2C4D9A0B3E130196] is automatically generated by QV to associate one-to-many relationships in the XML.