Example merge
This example shows what happens to a master data set and two update data sets when they are merged.
The key field is Horse, and all the data sets are sorted in descending order. Here is the master data set:
Horse | Freezemark | Mchip | Reg_Soc | Level |
---|---|---|---|---|
William | DAM7 | N/A | FPS | Adv |
Robin | DG36 | N/A | FPS | Nov |
Kayser | N/A | N/A | AHS | N/A |
Heathcliff | A1B1 | N/A | N/A | Adv |
Fairfax | N/A | N/A | FPS | N/A |
Chaz | N/A | a296100da | AHS | Inter |
Here is the Update 1 data set:
Horse | vacc. | last_worm |
---|---|---|
William | 07.07.02 | 12.10.02 |
Robin | 07.07.02 | 12.10.02 |
Kayser | 11.12.02 | 12.10.02 |
Heathcliff | 07.07.02 | 12.10.02 |
Fairfax | 11.12.02 | 12.10.02 |
Chaz | 10.02.02 | 12.10.02 |
Here is the Update 2 data set:
Horse | last_trim | shoes |
---|---|---|
William | 11.05.02 | N/A |
Robin | 12.03.02 | refit |
Kayser | 11.05.02 | N/A |
Heathcliff | 12.03.02 | new |
Fairfax | 12.03.02 | N/A |
Chaz | 12.03.02 | new |
Here is the merged data set output by the stage:
Horse | Freeze mark | Mchip | Reg. Soc | Level | vacc. | last worm | last trim | shoes |
---|---|---|---|---|---|---|---|---|
William | DAM7 | N/A | FPS | Adv | 07.07.02 | 12.10.02 | 11.05.02 | N/A |
Robin | DG36 | N?A | FPS | Nov | 07.07.02 | 12.10.02 | 12.03.02 | refit |
Kayser | N/A | N/A | AHS | Nov | 11.12.02 | 12.10.02 | 11.05.02 | N/A |
Heathcliff | A1B1 | N/A | N/A | Adv | 07.07.02 | 12.10.02 | 12.03.02 | new |
Fairfax | N/A | N/A | FPS | N/A | 11.12.02 | 12.10.02 | 12.03.02 | N/A |
Chaz | N/A | a2961da | AHS | Inter | 10.02.02 | 12.10.02 | 12.03.02 | new |