My Oracle Support Banner

ODI 12c UNPIVOT Component Not Allowing Selection of Multiple Columns (Doc ID 2010136.1)

Last updated on JULY 11, 2023

Applies to:

Oracle Data Integrator - Version 12.1.3.0.1 and later
Information in this document applies to any platform.

Symptoms

NOTE: In the examples below, the names represent a fictitious sample for clarity. Any similarity to actual environments, past or present, is purely coincidental and not intended in any manner.

The UNPIVOT component of ODI 12c is not allowing to select multiple columns.
Having 200 columns on some tables and having a 100 pairs of data (code+value) which are needed to be un-pivot in a way where the result is to pass those 200 columns to 2 in 100 rows.

Example Query (the important thing is the UNPIVOT, in reality this query does not have any real sense):

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.