is pivot functionality works good in all environments?
in HCM Extract
Summary: Hi, I am trying to convert data rows into columns using pivot function in BIP Reports. i tried to use in test environment the pivot functionality working good. when i got to development the pivot functionality is not working well. it is not giving some of the output attribute values as compared to test environment.
I used below pivot functionality in BIP REPORTS for both environments
select * from (
select LOAN_NUMBER, DOCUMENT_TYPE, DOCUMENT_ID
from my_table t
)
pivot
(
MIN(DOCUMENT_ID)
for DOCUMENT_TYPE in ('Voters ID','Pan card','Drivers licence')
)
Please let me know , if need any changes in development?
Tagged:
0