Hi,
Would like to get some help on creating a 4-way reconciliation that will only spit out the "differences".
Source1:
| ID | country | currency | type |
| sec1 | US | USD | eq |
| sec2 | US | USD | eq |
| sec3 | CA | CAD | eq |
| sec4 | SG | SGD | eq |
| sec5 | HK | HKD | eq |
Source2:
| ID | country | currency | type |
| sec1 | US | CAD | eq |
| sec2 | US | USD | fi |
| sec3 | CA | CAD | eq |
| sec4 | SG | SGD | eq |
| sec5 | HK | HKD | eq |
Source3:
| ID | country | currency | type |
| sec1 | US | USD | eq |
| sec2 | US | USD | fi |
| sec3 | CA | CAD | eq |
| sec4 | SG | SGD | eq |
| sec5 | JP | JPY | eq |
Source4:
| ID | country | currency | type |
| sec1 | US | USD | eq |
| sec2 | US | USD | eq |
| sec3 | CA | CAD | eq |
| sec4 | SG | SGD | eq |
| sec5 | HK | HKD | csh |
Result: should show the values of the specific fields of all sources when there is a break/breaks. If all of the values matched or when there is no break, then they don't have to be in the results.
| ID | Field | Source1 | Source2 | Source 3 | Source 4 |
| sec1 | currency | USD | CAD | USD | USD |
| sec2 | type | eq | fi | fi | eq |
| sec5 | country | HK | HK | JP | HK |
| sec5 | currency | HKD | HKD | JPY | HKD |
| sec5 | type | eq | eq | eq | csh |
It is easy to do this for 2 way rec, but I couldn't figure out once I added more sources in the mix. Appreciate any assistance on this. Thank you.
