Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
i have two sources to craete a report,
in first source i have YieldCurve,tenor,Nett fields.
in second source i have YieldCurve,shock,tenor in days,Scenarios.
in the second table we have 250 scenarios for each Yieldcurve.
so, what i have to show in the report is YieldCurve,Scenarios(1-250),shock,shock*Nett
how can i get this? if any one knows pls help me.
i used applymap and left join both are not working.
thanks.
First table..
Yieldcurve | Nett |
USD :IRS3M_LP | 105718 |
USD :IRS3M_LP | 69739 |
EUR :IRS1Y | 459485 |
EUR :IRS1Y | 716115 |
USD :IRS3M_LP | 1972593 |
USD :IRS3M_LP | 192042 |
USD :IRS3M_LP | 15852 |
USD :IRS3M_LP | 5234 |
USD :IRS3M_LP | 529092 |
CN1 :1YPBOCLOAN | 471101 |
second:
Scenario | Yieldcurve | Shock |
1 | USD:IRS3M_LP | -0.01057 |
12 | USD:IRS3M_LP | -0.06974 |
3 | EUR :IRS1Y | -0.04595 |
104 | EUR :IRS1Y | 0.071612 |
5 | USD:IRS3M_LP | 0.197259 |
26 | USD:IRS3M_LP | -0.0192 |
7 | USD:IRS3M_LP | -0.01585 |
8 | USD:IRS3M_LP | .000523 |
9 | USD:IRS3M_LP | -0.05291 |
195 | CN1 :1YPBOCLOAN -0.04711 |
i want o/p like this..
Scenario | Yieldcurve | Shock | Shock*Nett |
1 | USD :IRS3M_LP | -0.01057 | -1117.6296 |
12 | USD :IRS3M_LP | -0.06974 | -4863.5281 |
3 | EUR :IRS1Y | -0.04595 | -21112.647 |
104 | EUR :IRS1Y | 0.071612 | 51282.0693 |
5 | USD :IRS3M_LP | 0.197259 | 389112.314 |
26 | USD :IRS3M_LP | -0.0192 | -3688.013 |
7 | USD :IRS3M_LP | -0.01585 | -251.2859 |
8 | USD :IRS3M_LP | 0.000523 | 2.7394756 |
9 | USD :IRS3M_LP | -0.05291 | -27993.834 |
195 | CN1:1YPBOCLOAN | -0.04711 | -22193.615 |
Hi Soumya,
1)Apply map will help to you ,
2)just alias the name in First table tenor as ...tenor
so there is no Syn keys and you can proceed without doing any thing.
if not can you share the code which you written in the script?So that we will help to you.
For this Pivot table is better to UI,
Hi Thank you for reply.
tried alredy..
i have a common field YieldCurve,
ApplyMap('scenarios',YieldCurve,'') as [Scenario Number],
but i am getting only senario 1 remaining 249 scenarios not getting
can you share any sample data?
and also sample expected output
ApplyMap('scenarios',YieldCurve,'') as [Scenario Number],
by using this i am not getting any output getting blank.
what i have done is created a table(temp) with 250 Scenarios and i used applymap with the temp table,
now i am getting only one scenario
First table..
Yieldcurve | Nett |
USD :IRS3M_LP | 105718 |
USD :IRS3M_LP | 69739 |
EUR :IRS1Y | 459485 |
EUR :IRS1Y | 716115 |
USD :IRS3M_LP | 1972593 |
USD :IRS3M_LP | 192042 |
USD :IRS3M_LP | 15852 |
USD :IRS3M_LP | 5234 |
USD :IRS3M_LP | 529092 |
CN1 :1YPBOCLOAN | 471101 |
second:
Scenario | Yieldcurve | Shock |
1 | USD:IRS3M_LP | -0.01057 |
12 | USD:IRS3M_LP | -0.06974 |
3 | EUR :IRS1Y | -0.04595 |
104 | EUR :IRS1Y | 0.071612 |
5 | USD:IRS3M_LP | 0.197259 |
26 | USD:IRS3M_LP | -0.0192 |
7 | USD:IRS3M_LP | -0.01585 |
8 | USD:IRS3M_LP | .000523 |
9 | USD:IRS3M_LP | -0.05291 |
195 | CN1 :1YPBOCLOAN -0.04711 |
i want o/p like this..
Scenario | Yieldcurve | Shock | Shock*Nett |
1 | USD :IRS3M_LP | -0.01057 | -1117.6296 |
12 | USD :IRS3M_LP | -0.06974 | -4863.5281 |
3 | EUR :IRS1Y | -0.04595 | -21112.647 |
104 | EUR :IRS1Y | 0.071612 | 51282.0693 |
5 | USD :IRS3M_LP | 0.197259 | 389112.314 |
26 | USD :IRS3M_LP | -0.0192 | -3688.013 |
7 | USD :IRS3M_LP | -0.01585 | -251.2859 |
8 | USD :IRS3M_LP | 0.000523 | 2.7394756 |
9 | USD :IRS3M_LP | -0.05291 | -27993.834 |
195 | CN1:1YPBOCLOAN | -0.04711 | -22193.615 |