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?