How to display different email address types in separate columns — Cloud Customer Connect
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
Get Started with Redwood: Oracle Cloud SCM and Purchasing

How to display different email address types in separate columns

in Reporting and Analytics for HCM 9 comments

Summary:

We have a requirement to display separate columns for work email address and home email address, one row of data per employee.

Content (required):

From reading other posts on the topic of separate columns, it has been recommended to use pivot tables however we would prefer to write this directly into the SQL or XML if possible. I can get data in separate columns using CASE formula however am still seeing two rows per person in the results.

Version (include the version you are using, if applicable):

21D

Code Snippet (add any code snippets that support your topic, if applicable):

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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