3 Replies Latest reply: Jan 31, 2012 6:05 AM by omerbsgme RSS

    How to mix data from different sources in Script ?

    Frédéric Villemin

      Hi,

       

      this is a pretty simple but i can't manage to do that

       

      I have a script in which i have two queries

       

      firstone:

      LOAD myid,

      firstdate,

      mytype;

      SQL select myid, firstdate,mytype;

       

      secondone:

      LOAD myid,

      seconddate,

      otherinformation;

      SQL select myid, seconddate,otherinformation;

       

       

       

      I want to create an object like that :

      if(mytype='FIRSTTYPE',firstdate,seconddate)

       

      I think you have understood !  

      I can do that in an expression or variable but i would like to pre-calculate that during the Script Reload

      to be able to have a "virtual" table with myid and the result of my calculation

       

      Is it possible ? and how ?

       

      Thanks