3 Replies Latest reply: Jun 17, 2015 11:41 AM by Aissam Boumejjane RSS

    left join and intervalmatch

    Aissam Boumejjane

      Hi guys,

       

      Please look at the below script. When I load this script it works just fine.

      The momement I add a field, it load the script, but it Qlikview complains that it cannot find any of the fields in my facts table. The moment I remove the extra field it works great!

       

      What am i doing wrong?

      I tried to add the field in the first load (green color). later I tried to add the field in the preceding load. That didn't work.

       

       

      Left Join (TMP2_Facts)

      IntervalMatch(orderdate.KEY, OrderCompliant.KEY)

      Load

          numStartContract,

          numEndContract,

          OrderCompliant.KEY

      contractCompliant.KEY, TEST2

          OrderCompliant.KEY as orderContractcompliant //TEST1 did not work

       

      ;

      Load

          contractCompliant.KEY                AS OrderCompliant.KEY,

      contractCompliant.KEY,  //TEST 1 did not work

          Min(Num(contractBegindatum))        AS numStartContract,

          Max(contractEinddatum_Temp)            AS numEindeContract

      Resident TMP_Contract

      Group By

          contractCompliant.KEY;

              Drop Table TMP_Facts;

       

       

      Hope someone can explain.

       

      Cheers

       

      Sam