Split Database column in half

JR1

I was wondering how to split a column in half in order to speed up a fuzzy match join.  Figure A contains all the items.  Figure B contains items 1-5 while Figure C contains items 6-10.  After the fuzzy matching result has been completed on the separate columns, I want to rejoin them so that they resemble Figure A again with the addition of the Matched result score.  Is this possible?

ID	Item a	Item b
1	A	a
2	B	b
3	C	c
4	D	d
5	E	e
6	F	f
7	G	g
8	H	h
9	I	i
10	J	j

Figure A

ID	Item a	Item b
1	A	a
2	B	b
3	C	c
4	D	d
5	E	e

Figure B

ID	Item a	Item b
6	F	f
7	G	g
8	H	h
9	I	i
10	J	j

Figure C

NicoleJohnson

Use the Append tool rather than the Union tool - the median will be your Source (bottom input) and your original info will be the Target. This will add the median field on to every record in your original list, whereas Union will try to join your columns together by field/position. Example attached. Does that help?

Median.yxmd