0 / 0
Example merge

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:

Table 1. 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:

Table 2. 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:

Table 3. 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:

Table 4. Merged data set
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
Generative AI search and answer
These answers are generated by a large language model in watsonx.ai based on content from the product documentation. Learn more