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

Combining two rows of data into a single column

Received Response
155
Views
12
Comments

Summary:

Combining two rows of data into a single column


IF an employee has two degrees the expectation is to print it into a single row of data.

For example

Employee 123456 has two degrees B.Tech and M.Tech the analysis is printing it in the format


Emplid  Degree

123456  Bachelor's Degree

123456  Master Information Systems


Customer needs the data in the format

Emplid Degree

123456 Bachelor's Degree,Master Information Systems


Please suggest how this can be achieved using OTBI 

Content (required):


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


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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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