Combine data from two different rows

Gagan Marwah shared this question 4 years ago
Answered

Hello,


I am trying to combine the data from two different rows to show as one field based. Please see the attached file for more description.

Replies (6)

photo
2

Hello,


You want to use a 'Union Sub Query' or create a union in the underlying view. When finished your SQL should look similar to:

SELECT
  [Application System], [Application] as [APP or DB]
FROM
  Table1

UNION
SELECT
  [Application System], [Database]
FROM
  Table1

photo
2

Hello Gagan,

Thanks for reaching out with this question.

This can be done within the Yellowfin Report Builder via a Union Sub Query.

A good way to think about Union Sub Queries is - use them if you need to combine multiple fields into the one column.

More information on Union Sub Queries can be found here.

Please let me know if this information was useful.

Thanks,

Jared

photo
1

Hello Gagan,

Hope you're having a good week.

Just wanted to check-in and see how it's all going. Was there anything you were needing from me to help get this resolved?

Regards,

Jared

photo
1

Hello Gagan,

Hope you're having a good week.

Just wanted to check-in and see if you had a chance to review my response.

Regards,

Jared

photo
1

Hello Gagan,


I hope things are going well over there.


Just wanted to let you know I'll be closing this request due to inactivity. However, if you ever wanted to re-visit this or have anything else I can help you with, please let me know.


Regards,

Jared

photo
1

Hello,

Please close this request.

Thank you

Leave a Comment
 
Attach a file