1 Reply Latest reply: Jan 23, 2018 11:47 AM by Sunny Talwar RSS

    Opposite of a cross table

    stephane verissimo

      Hello everybody,

       

      I would like to do the opposite of the CROSS TABLE function

      I have a first table called CONTRIB_TABLE which has only one column named "Contributor":

       

      Contributor

      A

      B

      C

      D

      ...

       

      I have a second table named SP_TABLE which has 4 columns:

       

      Project ID | Project Name | Project Status | SP

       

      For each contributor in the CONTRIB_TABLE I would like to add a new column in the SP_TABLE in order to obtain


      Project ID | Project Name | Project Status | SP | A | B | C | D | ...

       

      Would you have a solution ?

       

      Thank you !