6 Replies Latest reply: Feb 16, 2018 1:06 PM by Jorge Aragon RSS

    Insert a record based on load data

    Jorge Aragon

      Hello all,

       

      I have a Reservations table in Excel format and when loading to QV need to create additional records when a reservation crosses month-end, so a record exists for month 1 and another for month 2.

       

            

      CustomerCheckInDateCheckOutDateSpanSalesPricePricePerNightRes. no.
      Agency 0128/01/201802/02/201811,570.00 3146555
      Agency 0110/03/201819/03/201803,204.00 3567091
      Agency 0224/01/201831/01/201801,540.00 2206267
      Agency 0223/02/201802/03/201811,582.70 226.16621
      Agency 0206/03/201813/03/201801,582.70 226.17241
      Agency 0222/03/201829/03/201801,666.00 2386991
      Agency 0227/03/201803/04/201811,582.70 226.16701
      Agency 0227/03/201803/04/201812,198.00 3147097
      Agency 0204/04/201811/04/201801,932.70 276.16159

       

       

      On this table, the first record must split in two as follows:

       

             

      CustomerCheckInDateCheckOutDateSpanSalesPricePricePerNightRes. no.
      Agency 0128/01/201831/02/201811,570.00 3146555
      Agency 0101/02/201802/02/201811,570.00 3146555

       

      Any clue as to how can I do this?

       

      Regards,

       

      Jorge Aragon