Restructuring data

[Haokun]

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

[pedrodrfaria · Accepted solution]

Hi @Haokun 

See below for the workflow:

Let me know if you have any questions or comments.

Pedro.

[Haokun]

hi @pedrodrfaria 

Thanks so much, it totally works...i have like 40 thousand transactions and it works for all the transactions.

very very appreciated.

Haokun