Problem loading XMLs

[#1]

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!

[#2]

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 · Accepted solution]

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

FilePath() & %Key_destino_2C4D9A0B3E130196 as key_ejecucion_SINC

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[#4]

Thank you very much Rob!! It works!

Have a good week.

[#5]

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

Have a good week!

[daniel_sonda]

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

Is a sequencial key based on [destino] field?

[rwunderlich]

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