Combine data from two different rows

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

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

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

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

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

Hello,

Please close this request.

Thank you