2 Replies Latest reply: Mar 30, 2014 1:18 AM by Ivan Trayanov RSS

    Synthetic keys while loading XML data

      Hi all,

       

       

      I am using qlikview for about 3 - 4 weeks now and allready came into several situation with synthetic key. Till now I was allways able to manage them but now I am a bit lost.

       

      I am trying to load XML Data from an official webside. The XML data consists out of several tables which are joint by a manual created key. The XML data needs to be loaded for several dates. The date itself is part of the XML URL.

      Since I am requesting allways the same 4 columns I would like to store them into one table in qlikview (like loading 2 Excel documents with the same columns, they get stroed by qlikview in the same table)

       

      In the beginning I use the script wizard to load the first Information from the XML Interface, everythink was working fine. When I add the second LOAD for the second date, I get synthetic keys and I do not really know why.

       

      Can someone help ?

       

      Skript example:

       

      LOAD

        klasse as KLASSE,

        quote as QUOTE,

        jackpot as JACKPOT,

        %Key_zahlenUndQuoten_429DBD973FACB660   as key // Key to parent table: TABLENAME2

      FROM [https://URL....&datum=25.12.2013] (XmlSimple, Table is [TABLENAME1]);

       

      Join

       

      LOAD

        [head/datum] as DATUM,

        %Key_zahlenUndQuoten_429DBD973FACB660 as key   // Key for this table: TABLENAME2

      FROM [https://URL....&datum=25.12.2013] (XmlSimple, Table is [TABLENAME2]);

       

      DROP field key;

       

       

      LOAD

        klasse as KLASSE,

        quote as QUOTE,

        jackpot as JACKPOT,

        %Key_zahlenUndQuoten_429DBD973FACB660   as key // Key to parent table: TABLENAME2

      FROM [https://URL....&datum=28.12.2013] (XmlSimple, Table is [TABLENAME1]);

       

      Join

       

      LOAD

        [head/datum] as DATUM,

        %Key_zahlenUndQuoten_429DBD973FACB660 as key   // Key for this table: TABLENAME2

      FROM [https://URL....&datum=28.12.2013] (XmlSimple, Table is [TABLENAME2]);

       

      DROP field key;