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
Then we need in the below way in oracle table
Is there any process to achieve this?
If so Please let us know
Thanks in advance
Thanks for your reply
We already tried http://s3.amazonaws.com/Ora/KM_IKM_Pivot.zip by following the link https://community.oracle.com/thread/904535?tstart=0
But unfortunately we got the same error which is mentioned in that link
org.apache.bsf.BSFException: exception from Jython:
Traceback (innermost last):
File "<string>", line 35, in ?
java.sql.SQLException: Invalid column name
I am newbie to odi - if possible can you please guide me how to do transpose in odi by considering excel as source and oracle as target