2 Replies Latest reply: May 23, 2017 12:59 PM by Carlos Alberto Garcia Michel RSS

    How to create new lines with given information in a fiel

    Carlos Alberto Garcia Michel

      I have a data base with information about a Hotel reservations in the next format:

       

       

      HotelRoom TypeCheck InCheck out
      XY01/01/201705/01/2017

       

      And I need to transform each date in a line like this:

       

       

      HotelRoom Type     Check In   Check out
      XY01/01/201705/01/2017
      XY02/01/201705/01/2017
      XY03/01/201705/01/2017
      XY04/01/201705/01/2017
      XY05/01/201705/01/2017

       

      Thank you !