2 Replies Latest reply: Jan 25, 2012 10:05 AM by Damien Garzilli RSS

    Script / Loading first value

      Hi,

       

      I'm trying to load, for all of my customers, the first date they ordered.

       

      I have 2 tables which are basically as following :

      ORDERS :

      LOAD

      order_id,

      customer_id,

      order_date,

      order_turnover

      FROM QVD/orders.qvd

       

      CUSTOMERS :

      LOAD

      customer_id,

      customer_name,

      customer_registration_date

      FROM QVD/customers.qvd

       

      I'd like to add a column in my "CUSTOMERS" table which would be the first order date (i want it to be pre-calculated in the script, not calculated within the report).

       

      Thanks in advance for your help !

       

      Damien