Hello,
Hope someone can help, I'd like to compare data using multiple sources and return a result to each set of the column if there's a mismatch in any of the sources.
example: 4 different sources
| SOURCE 1 | | SOURCE 2 | | SOURCE 3 | | SOURCE 4 |
| ID | NAME | TYPE | CCY | | ID | NAME | TYPE | CCY | | ID | NAME | TYPE | CCY | | ID | NAME | TYPE | CCY |
| INST1 | HELLO1 | EQ | USD | | INST1 | HELLO1 | EQ | USD | | INST1 | HELLO1 | EQ | USD | | INST1 | HELLO1 | CS | USD |
| INST2 | HELLO2 | EQ | JPY | | INST2 | HELLO2 | EQ | JPY | | INST2 | HELLO2a | EQ | JPY | | INST2 | HELLO2 | EQ | JPY |
| INST3 | HELLO3 | EQ | HKD | | INST3 | HELLO3 | EQ | CNY | | INST3 | HELLO3 | EQ | HKD | | INST3 | HELLO3 | EQ | HKD |
| INST4 | HELLO4 | EQ | GBP | | INST4 | HELLO4 | EQ | GBP | | INST4 | HELLO4 | EQ | GBP | | INST4 | HELLO4_S | EQ | GBP |
| INST5 | HELLO5 | FI | USD | | INST5 | HELLO5 | FI | USD | | INST5 | HELLO5 | FI | USD | | INST5 | HELLO5 | EQ | USD |
| INST6 | HELLO6 | FI | USD | | INST6 | HELLO6 | FI | USD | | INST6 | HELLO_6 | FI | USD | | INST6 | HELLO_6 | FI | MYR |
expected result:
| ID | 1_NAME | 2_NAME | 3_NAME | 4_NAME | NAME_REVIEW | 1_TYPE | 2_TYPE | 3_TYPE | 4_TYPE | TYPE_REVIEW | 1_CCY | 2_CCY | 3_CCY | 4_CCY | CCY_REVIEW |
| INST1 | HELLO1 | HELLO1 | HELLO1 | HELLO1 | MATCH | EQ | EQ | EQ | CS | MISMATCH | USD | USD | USD | USD | MATCH |
| INST2 | HELLO2 | HELLO2 | HELLO2-a | HELLO2 | MISMATCH | EQ | EQ | EQ | EQ | MATCH | JPY | JPY | JPY | JPY | MATCH |
| INST3 | HELLO3 | HELLO3 | HELLO3 | HELLO3 | MATCH | EQ | EQ | EQ | EQ | MATCH | HKD | CNY | HKD | HKD | MISMATCH |
| INST4 | HELLO4 | HELLO4 | HELLO4 | HELLO4_S | MISMATCH | EQ | EQ | EQ | EQ | MATCH | GBP | GBP | GBP | GBP | MATCH |
| INST5 | HELLO5 | HELLO5 | HELLO5 | HELLO5 | MATCH | FI | FI | EQ | EQ | MISMATCH | USD | USD | USD | USD | MATCH |
Most of the existing cases are comparing two sources only so hope to get a sample of multiple source compare.
Thanks in advance!
