Connecting two different tables from XML file

Fri, 04 Mar 2016 21:38:03 GMT

I am trying to connect info from one table to another from a XML-file.

I have several XML-files with similar structure, which I want import to clickview:

XML-file example:

<Car> Toyota </Car>

</Details>

<Fuel>

</result>

</result>

</result>

</Fuel>

</Register>

There is only one <Car> for each file - so this is unique for each file - all the info under result is connected to this specific car. Next file can be the same car, or another one. Problem is that I want to connect Details table with all the info under the Fuel table.

I have tried to write it like this:

LOAD

[Details/Car] as Car,

[Fuel/Result/Station] as Station,

[Fuel/Result/SampleDate] as SampleDate,

[Fuel/Result/ControlNoCd] as ControlNoCd,

[Fuel/Result/Amount] as Amount,

[Fuel/Result/Quality] as Quality,

%Key_report_16926E6E9269865A // Key for this table: register

FROM (XmlSimple, Table is [Register]);

// End of [*.xml] LOAD statements

The problem I meet with this script, is that only the first Result-node is displayed. After it is finished with results from station "shell", it does not take out the values from "Statoil" and "Chevron"...

It has to be said, I am no programmer, but trying to make a simple script to implement it in qlikview with my limited knowledge...

Re: Connecting two different tables from XML file

Chanty4u — Thu, 17 Mar 2016 12:09:43 GMT

try dis

Re: how to read xml files in a loop

Re: Connecting two different tables from XML file

Thu, 17 Mar 2016 15:12:36 GMT

Thanks. Not exactly same problem, but it forwarded me to a good solution. Key is to use filename as id, and connect the tables. If you insert on xml file, and replace filename with *.xml, it will go through all the nodes.

Add a unique id field for each xml file loaded for each row

Re: Connecting two different tables from XML file

Chanty4u — Thu, 17 Mar 2016 16:25:28 GMT

cool man

topic Re: Connecting two different tables from XML file in QlikView

Connecting two different tables from XML file

Re: Connecting two different tables from XML file

Re: Connecting two different tables from XML file

Re: Connecting two different tables from XML file