Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Problem loading XMLs

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!

Tags (3)
1 Solution

Accepted Solutions

Re: Problem loading XMLs

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

6 Replies
Not applicable

Re: Problem loading XMLs

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.

Re: Problem loading XMLs

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

Not applicable

Re: Problem loading XMLs

Thank you very much Rob!! It works!

Have a good week.

Not applicable

Re: Problem loading XMLs

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

Have a good week!

daniel_sonda
New Contributor II

Re: Problem loading XMLs

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

Is a sequencial key based on [destino] field?


Re: Problem loading XMLs

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

Community Browser