Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Connecting two different tables from XML file

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:

<Register>

     <Details>

          <Car> Toyota </Car>

     </Details>

     <Fuel>

          <result Station="Shell" SampleDate="211215" ControlNoCd="1122332 ">

              <Amount> 213L </Amount>

              <Quality> A4 </Quality>

          </result>

          <result Station="Statoil" SampleDate="191115" ControlNoCd="1156332 ">

              <Amount> 140L </Amount>

              <Quality> A1 </Quality>

          </result>

          <result Station="Chevron" SampleDate="011215" ControlNoCd="367332 ">

              <Amount> 300L </Amount>

              <Quality> A1 </Quality>

          </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...

Tags (1)
1 Solution

Accepted Solutions
sureshqv
Esteemed Contributor III

Re: Connecting two different tables from XML file

3 Replies
sureshqv
Esteemed Contributor III

Re: Connecting two different tables from XML file

Not applicable

Re: Connecting two different tables from XML file

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

sureshqv
Esteemed Contributor III

Re: Connecting two different tables from XML file

cool man

Community Browser