Hi,
I want to pivot a column which increases dynamically into multiple columns. Well my requirement is that the below file is generated from Essbase and I would like to have every 11th and 13th rows as two columns in the source table and neglect the other rows.The data is being generated as a set of 13rows. Every new additions will be in a set of 13 rows. I'm very new new to these implementations. I would greatly appreciate if you could help me with any methodologies or code needed to grab them.
I have seen "Pivot" component in ODI 12c, but when I read articles like these "https://blogs.oracle.com/dataintegration/pivoting-data-in-odi-12c ", it's actually for a min of two columns(as far as I believe, could be wrong though).
Thank you and looking forward for your suggestions.