9 Replies Latest reply: Nov 24, 2015 7:17 AM by Christoph Hebig RSS

    Different Number of Synthetic Keys

    Christoph Hebig

      Hi there!

       

      Can someone tell me why i get different number of synthetic keys when i load my script like this:

       

      1. Version:

      Here i get 6 syn keys

       

      Inventory_Storage:

      LOAD ExpNr,

          area,

          "buffer",

          "TimeStamp" as Zeitpunkt,

          "current",

          "min",...

       

       

      JOIN LOAD ExpNr,

          area,

          "buffer",

          "time" as Zeitpunkt,

          "min", ...

       

      StatAverage:

      LOAD ExpNr,

          area,

          "buffer",

          "time" as Zeitpunkt,

          "min",...

       

       

      JOIN (StatAverage) LOAD ExpNr,

          area,

          "buffer",

          "TimeStamp" as Zeitpunkt,

          "current",

          "min",...

       

       

       

      2. Version:

      Here i get 3 Syn Keys

       

      StatAverage:

      LOAD ExpNr,

          area,

          "buffer",

          "time" as Zeitpunkt,

          "min",...

       

      JOIN (StatAverage) LOAD ExpNr,

          area,

          "buffer",

          "TimeStamp" as Zeitpunkt,

          "current",

          "min",...

       

      Inventory_Storage:

      LOAD ExpNr,

          area,

          "buffer",

          "TimeStamp" as Zeitpunkt,

          "current",

          "min",...


      JOIN LOAD ExpNr,

          area,

          "buffer",

          "time" as Zeitpunkt,

          "min", ...

       

       

      Regards

      Chris

       

      EDIT: I removed the SELECT parts and the rest of the Syn-key columns (everything after the ... is identical on all tables)