Applying same formula over multiple fields in a particular order

[Eug_teng]

Hi all,

I would like to apply a formula to multiple fields in a particular order based on their field headers but I am unsure of how to go about doing it. Do see the problem below:

Sample Input

Number	Code	Address	Right_Number	Right_Code	Right_Address
123	ABC	street 11	123	ABC	street 11
456	DEF	street 12	457	DEF	street 13
789	GHI	street 13	711	GHQ	street 13

I would like to match the value in this order:

• "Number" -> "Right_Number"
• "Code" -> "Right_Code"
• "Address" -> "Right_Address"

If the values are matching, an additional column should be created with the output "Good", else "Bad"

Sample Ouput

Number	Code	Address	Right_Number	Right_Code	Right_Address	Number_Review	Code_Review	Address_Review
123	ABC	street 11	123	ABC	street 11	Good	Good	Good
456	DEF	street 12	457	DEF	street 13	Bad	Good	Bad
789	GHI	street 13	711	GHQ	street 13	Bad	Bad	Good

How do I get this output without having to use the formula tool and matching them based on field header name assuming I have alot of fields instead of just these few?

Thank you!

[Qiu]

@Eug_teng 
Hope this works for you and I believe you will agree that we have to give a definitive input for the columns for columns to be grouped. or your table names follow a certain pattern.