6 Replies Latest reply: Jul 6, 2018 9:41 AM by Jamel Messaoud RSS

    Change Data Format

    Jamel Messaoud

      Hi guys,

       

      I have some data imported that looks like this..

        

      Type01/01/201802/01/2018
      In1060
      Out2070
      Total Balance30130

       

      Within my load script I want to transform the output to this

         

      DateInOutTotal Balance
      01/01/2018102030
      02/01/20186070130

       

      Is this possible at all?

       

      Thanks

      J