4 Replies Latest reply on Sep 28, 2017 12:44 PM by Rohit Trehan

    How to create a logical column which is an "OR" of 3 existing columns in the same table in the front-end or RPD ?

    Rohit Trehan

      Hi

       

      I am interested to implement the following scenario in OBIEE front-end ot RPD.

      My goal is to create a Pseudo/Logical column in the table which can unpivot or unflatten the 3 columns Name 1, Name 2 and Name 3.

       

      I can create this column by creating an Opaque view which the SQL:

      select distinct Name1 as Pseudo_Col

      from Table 1

      Union

      select distinct Name2 as Pseudo_Col

      from Table 1

      Union

      select distinct Name2 as Pseudo_Col

      from Table 1

       

      But i don't want to go that route.

      How can i do that in the same table.

       

      Thanks

      Rohit

       

      Table 1

      ID

      Name 1

      Name 2

      Name 3

      Pseudo/Logical Col
      = Col B UNION Col C union Col D

      1243

      bazooka

      whiskey

      Rum

      bazooka

       

       

       

       

      whiskey

       

       

       

       

      Rum