You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Can we use Pivot dynamically in BIP

Received Response
95
Views
10
Comments

Summary:

Hi Experts ,

We are having a requirement to convert rows to columns dynamically we used pivot to achieve this but by using pivot we need to hardcode values which is not dynamic.Is there any approach to address this issue.

SQL code:

SELECT *

FROM (

SELECT QCT.NAME

,COALESCE(TO_CHAR(round(qsr.RESULT_VALUE_NUM, 2)), TO_CHAR(qsr.RESULT_VALUE_CHAR), TO_CHAR(qsr.RESULT_VALUE_DATE, 'MM/DD/YYYY')) RESULT_VALUE_NUM

FROM QA_INSPECTION_PLANS_B QIPB

,QA_INSPECTION_PLANS_TL QIPT

,INV_ORG_PARAMETERS IOP

,QA_IP_EVENTS QIE_Inspec --Inspection Details Table

,QA_RESULT_ACTIONS QRA

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!