Example Data
This example shows two data sets being compared, and the data set that is output by the Compare stage.
This example shows two data sets being compared, and the data set that is output by the Compare stage when it has compared them.
This is the first data set:
bcol0 | bcol1 | bcol2 | bcol3 | bcol4 |
---|---|---|---|---|
0 | 0 | 0 | 0 | a |
1 | 7 | 1 | 1 | b |
2 | 2 | 2 | 2 | c |
3 | 3 | 3 | 3 | d |
4 | 5 | 4 | 4 | e |
5 | 2 | 5 | 5 | f |
6 | 6 | 6 | 6 | g |
7 | 7 | 7 | 7 | h |
8 | 8 | 8 | 8 | i |
9 | 9 | 9 | 9 | j |
This is the second data set:
bcol0 | bcol1 | bcol2 | bcol3 | bcol4 |
---|---|---|---|---|
0 | 0 | 0 | 0 | a |
1 | 1 | 1 | 1 | b |
2 | 2 | 2 | 2 | c |
3 | 3 | 3 | 3 | d |
4 | 4 | 4 | 4 | e |
5 | 5 | 5 | 5 | f |
6 | 6 | 6 | 6 | g |
7 | 7 | 7 | 7 | h |
8 | 8 | 8 | 8 | i |
9 | 9 | 9 | 9 | j |
The stage compares on the Key columns bcol1 and bcol4. This is the output data set:
Result | First | Second | ||||||||
---|---|---|---|---|---|---|---|---|---|---|
bcol0 | bcol1 | bcol2 | bcol3 | bcol4 | bcol0 | bcol1 | bcol2 | bcol3 | bcol4 | |
0 | 0 | 0 | 0 | 0 | a | 0 | 0 | 0 | 0 | a |
2 | 1 | 7 | 1 | 1 | b | 1 | 1 | 1 | 1 | b |
0 | 2 | 2 | 2 | 2 | c | 2 | 2 | 2 | 2 | c |
0 | 3 | 3 | 3 | 3 | d | 3 | 3 | 3 | 3 | d |
2 | 4 | 5 | 4 | 4 | e | 4 | 4 | 4 | 4 | e |
-1 | 5 | 2 | 5 | 5 | f | 5 | 5 | 5 | 5 | f |
0 | 6 | 6 | 6 | 6 | g | 6 | 6 | 6 | 6 | g |
0 | 7 | 7 | 7 | 7 | h | 7 | 7 | 7 | 7 | h |
0 | 8 | 8 | 8 | 8 | i | 8 | 8 | 8 | 8 | i |
0 | 9 | 9 | 9 | 9 | j | 9 | 9 | 9 | 9 | j |