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.
Solved! Go to Solution.
Hey @jillv
Here is one way to do it which got me to your desired result.
Please accept as solution if this solved your issue.
Hope this helps!
thank you everyone for those who answered, I really appreciate it!