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:
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!
@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.