<?xml version="1.0" encoding="UTF-8"?>
<config>
	<datasources>
		<from type="database">
			<dbconnection user=""
						  password=""
						  host=""
						  name="">
				<table name="fyapps">
					<select>id,ssn,firstname,lastname</select>
					<limit>5</limit>
				</table>
				<table name="fyapp_educations">
					<select>fyapp_id,name</select>

				</table>
				<table name="fyapp_ethnicities">
					<select>fyapp_id,ethnicity_code</select>

				</table>
				<merge fieldOne="fyapps.id" fieldTwo="fyapp_educations.fyapp_id" />
				<merge fieldOne="fyapps.id" fieldTwo="fyapp_ethnicities.fyapp_id" />
			</dbconnection>
		</from>
		<to type="delimited_file">
			<file path="/home/bclark/tmp"
				  filename="output.txt"
				  delimiter="," />
		</to>
	</datasources>
	<transforms>
	</transforms>
	<map>
		<field>
			<to position="0" />
			<from name="fyapps.lastname" />
		</field>
		<field>
			<from name="fyapps.firstname" />
			<to position="1" />
		</field>
		<field>
			<from name="fyapps.firstname" />
			<to position="1" />
		</field>
		<field>
			<from name="fyapps.firstname" />
			<to position="1" />
		</field>
	</map>
</config>