Skip to Content
0
Former Member
Dec 05, 2011 at 09:16 PM

Creating Pivot view using Case Statement

45 Views

I have a table of data in SQL server like below.

Cust no Relation Relation Name

1000 vendor ABC

1000 Sold-To XYZ

1000 Ship-To XYZ

1000 Payer XYZ

I used CASE statements in universe to get this data in single row like below in a vertical table.

Custno vendor sold-to ship-to payer

1000 ABC XYZ XYZ XYZ.

But the display still displaying 4 rows

Cust no Vendor Sold-To Ship-To Payer

1000 ABC

1000 XYZ

1000 XYZ

1000 XYZ.

How to use SQL Pivot functionality in Universe?