7 Replies Latest reply: Jun 10, 2014 5:34 PM by Rachael Chan RSS

    More than one resident table in load statement

      Is it possible to reference fields from multiple tables in the load script? Here is what I'm trying to do:

       

      • Calendar.qvd
        Fields: Date, Year, Month
      • Account.qvd
        Fields: payments, charges

       

      How do I write a statement such that:

      if(Date>YYYY-MM-DD, payments*2, payments) as payments