4 Replies Latest reply: Jan 8, 2014 7:53 AM by 1048512 RSS

    Transposing columns to rows in excel through ODI

    1048512

      Hi all,

      We are trying to transpose Columns to rows along with Headers considering excel as source and oracle table as target

      For example we are having metadata and data in Excel sheet like below

      Metadata:- A,B,TC1,TD1,L1,U1,TC2,TD2,L2,U2,TC3,TD3,L3,U3

      Data:-        X,Y,1,2,3,4,5,6,7,8,9,10,11,12

                       M,N,a,b,c,d,e,f,g,h,i,j,k,l

      Then we need in the below way in oracle table

      A,B,TC1,TD1,L1,U1

      X,Y,1,2,3,4

      X,Y,5,6,7,8

      X,Y,9,10,11,12

      M,N,a,b,c,d

      M,N,e,f,g,h

      M,N,i,j,k,l


      Is there any process to achieve this?

      If so Please let us know


      Thanks in advance