Opposite of a cross table

stephane_veriss — Tue, 23 Jan 2018 14:38:45 GMT

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

...

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 !

Re: Opposite of a cross table

sunny_talwar — Tue, 23 Jan 2018 16:47:20 GMT

Opposite of CrossTable would be The Generic Load