Hey Guys, i am struggling with this data re-structuring... are you able to give me some clues on how to get the ideal output structure i am looking for?
thanks so much.
this is the current structure:
Field_11 | Field_12 | Field_13 | Field_14 | Field_15 | Field_16 |
Compute: | P_Yield_To_Maturity | | | | |
Expected | Actual | Compare Result: | | | |
passed | | | | | |
Comparator Method | Comparator Deviation | | | | |
Result: | 5.00% | 5.00% | passed | numeric-absolute | 1.00E-04 |
Returncode: | 0 | not-tested | exact | | |
Message: | not-tested | exact | | | |
Fieldref: | not-tested | exact | | | |
Duration: | 197138 | not-tested | ignore | | |
Compute: | P_Running_Yield_To_Maturity | | | | |
Expected | Actual | Compare Result: | | | |
passed | | | | | |
Comparator Method | Comparator Deviation | | | | |
Result: | 6.00% | 6.00% | passed | numeric-absolute | 1.00E-04 |
Returncode: | 0 | not-tested | exact | | |
Message: | not-tested | exact | | | |
Fieldref: | not-tested | exact | | | |
Duration: | 3210 | not-tested | ignore | | |
Do you have any idea how I can transform to the below structure… so the P_Yield_To_Maturity needs to concatenate with Expected and Actual from the next row. The Field 13 needs to get the % from result row also.
this is what i am looking for:
Field_12 | Field_13 |
P_Yield_To_Maturity Expected | 5.00% |
P_Yield_To_Maturity Actual | 5.00% |
Result | passed |
P_Running_Yield_To_Maturity Expected | 6.00% |
P_Running_Yield_To_Maturity Actual | 6.00% |
Result | passed |
