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:
[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...
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.