Hi All,
i have the below Source table. i need to add 2 rows for each row in the output table with 2 extra columns as below
Source table
| portfolio_code | class_scheme_code | class_scheme_node_name | class_scheme_node_name_benchmark | class_scheme_node_code | date_from | date_to | contribution_base | sequence | return_portfolio_base | log_portfolio_base | log_benchmark_base | log_contribution_base | Excess_Return | ExcessReturnsHeader | client_name | client_type | Portfolio_Node_Name_Override | Benchmark_Node_Name_Override |
| PORT | PORTCS | REAL ESTATE | REAL ESTATE Benchmark | REALEST | 01/01/2023 | 01/01/2023 | 0 | .000.002.001.000.000 | 0 | 100 | 200 | 0 | 100.00 | Excess Returns | Client | P | Real Estate | |
| PORT | PORTCS | REAL ESTATE | REAL ESTATE Benchmark | REALEST | 01/02/2023 | 01/02/2023 | 0 | .000.002.001.000.000 | 0 | 102 | 100 | 0 | 150.00 | Excess Returns | Client | P | Real Estate | |
| PORT | PORTCS | EQ | EQ Benchmark | CDNEQ | 01/02/2023 | 01/02/2023 | 0 | .000.005.001.000 | 0 | 120 | 5 | 0 | 200.00 | Excess Returns | Client | P | | |
New Column: Asset will have data from class_scheme_node_name,class_scheme_node_name_benchmark and ExcessReturnsHeader columns
New Column: Returns will have data from log_portfolio_base,log_benchmark_base and Excess_Return columns
all the other columns will be repeated in the extra 2 rows added.
Please help
output table
| Asset | Returns | portfolio_code | class_scheme_code | class_scheme_node_name | class_scheme_node_name_benchmark | class_scheme_node_code | date_from | date_to | contribution_base | sequence | return_portfolio_base | log_portfolio_base | log_benchmark_base | log_contribution_base | Excess_Return | ExcessReturnsHeader | client_name | client_type | Portfolio_Node_Name_Override | Benchmark_Node_Name_Override |
| REAL ESTATE | 100 | PORT | PORTCS | REAL ESTATE | REAL ESTATE Benchmark | REALEST | 01/01/2023 | 01/01/2023 | 0 | .000.002.001.000.000 | 0 | 100 | 200 | 0 | 311.00 | Excess Returns | Client | P | Real Estate | |
| REAL ESTATE Benchmark | 200 | PORT | PORTCS | REAL ESTATE | REAL ESTATE Benchmark | REALEST | 01/01/2023 | 01/01/2023 | 0 | .000.002.001.000.000 | 0 | 100 | 200 | 0 | 311.00 | Excess Returns | Client | P | Real Estate | |
| Excess Returns | 311.00 | PORT | PORTCS | REAL ESTATE | REAL ESTATE Benchmark | REALEST | 01/01/2023 | 01/01/2023 | 0 | .000.002.001.000.000 | 0 | 100 | 200 | 0 | 311.00 | Excess Returns | Client | P | Real Estate | |
| REAL ESTATE | 102 | PORT | PORTCS | REAL ESTATE | REAL ESTATE Benchmark | REALEST | 01/02/2023 | 01/02/2023 | 0 | .000.002.001.000.000 | 0 | 102 | 100 | 0 | 314.00 | Excess Returns | Client | P | Real Estate | |
| REAL ESTATE Benchmark | 100 | PORT | PORTCS | REAL ESTATE | REAL ESTATE Benchmark | REALEST | 01/02/2023 | 01/02/2023 | 0 | .000.002.001.000.000 | 0 | 102 | 100 | 0 | 314.00 | Excess Returns | Client | P | Real Estate | |
| Excess Returns | 314 | PORT | PORTCS | REAL ESTATE | REAL ESTATE Benchmark | REALEST | 01/02/2023 | 01/02/2023 | 0 | .000.002.001.000.000 | 0 | 102 | 100 | 0 | 314.00 | Excess Returns | Client | P | Real Estate | |
| EQ | 150 | PORT | PORTCS | EQ | EQ Benchmark | CDNEQ | 01/01/2023 | 01/01/2023 | 0 | .000.005.001.000 | 0 | 150 | 25 | 0 | 315.00 | Excess Returns | Client | P | | |
| EQ Benchmark | 25 | PORT | PORTCS | EQ | EQ Benchmark | CDNEQ | 01/01/2023 | 01/01/2023 | 0 | .000.005.001.000 | 0 | 150 | 25 | 0 | 315.00 | Excess Returns | Client | P | | |
| Excess Returns | 315 | PORT | PORTCS | EQ | EQ Benchmark | CDNEQ | 01/02/2023 | 01/02/2023 | 0 | .000.005.001.000 | 0 | 120 | 5 | 0 | 315.00 | Excess Returns | Client | P | | |
