5 Replies Latest reply: Jul 18, 2017 2:09 AM by Arvind Patil RSS

    Need help with an application i inherited

    Syed Quadri

      Hello,

       

      I am having an issue with an application i inherited. I am still a learner in qlikview. The application is developed already but i am not able to understand why the previous developer used a function in the script. there are basically three tables. two tables have a common key but one does not have any common key.  the developer used interval match function and left joined it to one of the table with common key.

       

      here is the script

       

       

      //1st table

      campaign:

      LOAD [Campaign id],

      Start,

        End,

      Name,

        Cost

      FROM Campaign-Source-Data.xlsx (ooxml, embedded labels, table is campaign);

       

       

      //2nd Table

      LOAD EmailReceivedDate,

      EmailOpenTime,

      [Customer id],

      Month,

      Year,

      1 As Email,

      Clicked

       

      FROM Campaign-Source-Data.xlsx (ooxml, embedded labels, table is clicks);

       

      //i am trying to learn why he did this?

      inner Join

      IntervalMatch(EmailOpenTime)

      LOAD

      Start,

      End

      Resident campaign;

       

      Left Join

      LOAD

      [Campaign id],

           Start,

           End,

           Name as [Campaign Name],

           Cost as [Campaign Cost]

          

         Resident campaign;

       

       

      DROP Table campaign;

       

       

      customers:

      LOAD Customer as [Customer id],

      Age,

      Country,

      Gender

      FROM Campaign-Source-Data.xlsx

      (ooxml, embedded labels, table is customers);

       

       

       

      I would really appreciate any help with this.

       

      Thank you,

      SMQ