3 Replies Latest reply: Jul 6, 2012 6:58 AM by gershova RSS

    Rows to colums

      Hello,

       

      I have the following issue.

       

      I've imported a CSV file with our helpdesk information. Everything is sorted out except one row wich contains the serviceID history. The rook looks like this:

       

      [date] [time] status information

      [date] [time] status information

      [date] [time] status information

      [date] [time] status information

      [date] [time] status information

      [date] [time] status information

       

      I would like to split these lines to this:

       

      [date] [time] status information    |   [date] [time] status information   |       etc

                                                       |                                                 |                 |

                                                       |                                                 |                 |

       

       

      Is there a way to do this in the loadscript?

       

      Thanks!