Job Documentation
Generated by Talend Open Studio


PROJECT NAME London GENERATION DATE 24-mar-2010 1:10:59
AUTHOR respinosa@terramiticapark.comT.O.S VERSION 4.0.0.M1_r33789

Summary

Project Description
Job Description
Job Preview Picture
Job Settings
Context List
Component List
Components Description


Project Description


Properties Values
NameLondon
Languagejava
Description 
Proyecto BI de Analisis de Datos Públicos


Job Description


Properties Values
NameT_elecciones
Authorrespinosa@terramiticapark.com
Version0.1
Purpose
Status
Description 
Creation22-mar-2010 16:10:03
							Modification						23-mar-2010 20:21:04

							Job Preview Picture						

No image available
tFileInputDelimited_1tFileInputDelimited_2tFileInputDelimited_3tFilterRow_1tFilterRow_2tFilterRow_3tMap_1tMap_2tMap_3tMysqlOutput_1tUnite_1

Job settings
Extra settings

							Name													Value						
COMP_DEFAULT_FILE_DIRC:/Talend/TOS-Win32-r33789-V4.0.0M1/workspace
Multi thread executionfalse
Implicit tContextLoadfalse


Stats & Logs

							Name													Value						
Use statistics (tStatCatcher)false
Use logs (tLogCatcher)false
Use volumetrics (tFlowMeterCatcher)false
On Consolefalse
On Filesfalse
On Databasesfalse
Catch components statisticsfalse
Catch runtime errorstrue
Catch user errorstrue
Catch user warningstrue


Context List
									Context :									Default

								Name															Prompt															Need Prompt?															Type															Value															Source							




Component List
							Component Name													Component Type						
tFileInputDelimited_1tFileInputDelimited
tFileInputDelimited_2tFileInputDelimited
tFileInputDelimited_3tFileInputDelimited
tFilterRow_1tFilterRow
tFilterRow_2tFilterRow
tFilterRow_3tFilterRow
tMap_1tMap
tMap_2tMap
tMap_3tMap
tMysqlOutput_1tMysqlOutput
tUnite_1tUnite

						Components Description					
									Component:  									tFileInputDelimited

								     															UNIQUE NAME							tFileInputDelimited_1								INPUT(S)							none
								LABEL							europeas_2004								OUTPUT(S)							tFilterRow_1

Component Parameters:
								Properties															Values							
Activatetrue
tStatCatcher Statisticsfalse
File Name/Input Stream"D:/BI/Info BI/BLog/Entrada 14.11/Datos/Elecciones Europeas 2004.csv"
Row Separator"\n"
Field Separator","
Opciones CSVfalse
Header1
Footer0
Limit
Skip empty rowsfalse
Die on errorfalse
Advanced separator(for number)false
Extract lines at randomfalse
Trim all columnfalse
Check column to trim[{SCHEMA_COLUMN=Code, TRIM=false}, {SCHEMA_COLUMN=Borough, TRIM=false}, {SCHEMA_COLUMN=Number_votes_Conservatives, TRIM=false}, {SCHEMA_COLUMN=Number_votes_Labour, TRIM=false}, {SCHEMA_COLUMN=Number_votes_Liberal_Democrats, TRIM=false}, {SCHEMA_COLUMN=Number_votes_Green, TRIM=false}, {SCHEMA_COLUMN=Number_votes_UKIP, TRIM=false}, {SCHEMA_COLUMN=Number_votes_BNP, TRIM=false}, {SCHEMA_COLUMN=Number_votes_Christian_Peoples_Alliance, TRIM=false}, {SCHEMA_COLUMN=Number_votes_English_Democrats, TRIM=false}, {SCHEMA_COLUMN=Number_votes_Respect___The_Unity_Coalition, TRIM=false}, {SCHEMA_COLUMN=Number_votes_Peoples_party_for_better_government, TRIM=false}, {SCHEMA_COLUMN=Number_votes_TOTAL_Good_Votes, TRIM=false}, {SCHEMA_COLUMN=Number_spoils_Uncertain_or_Blank, TRIM=false}, {SCHEMA_COLUMN=Number_spoils_Voting_for_too_many_candidates, TRIM=false}, {SCHEMA_COLUMN=Number_spoils_Writing_a_mark_by_which_the_voter_could_be_identified, TRIM=false}, {SCHEMA_COLUMN=Number_spoils_Lack_of_Official_Mark, TRIM=false}, {SCHEMA_COLUMN=Number_spoils_TOTAL_Spoils, TRIM=false}, {SCHEMA_COLUMN=Electorate, TRIM=false}, {SCHEMA_COLUMN=Ballot_papers, TRIM=false}, {SCHEMA_COLUMN=percent_poll, TRIM=false}, {SCHEMA_COLUMN=Percent_good_votes_Conservatives, TRIM=false}, {SCHEMA_COLUMN=Percent_good_votes_Labour, TRIM=false}, {SCHEMA_COLUMN=Percent_good_votes_Liberal_Democrats, TRIM=false}, {SCHEMA_COLUMN=Percent_good_votes_Green, TRIM=false}, {SCHEMA_COLUMN=Percent_good_votes_UKIP, TRIM=false}, {SCHEMA_COLUMN=Percent_good_votes_BNP, TRIM=false}, {SCHEMA_COLUMN=Percent_good_votes_Christian_Peoples_Alliance, TRIM=false}, {SCHEMA_COLUMN=Percent_good_votes_English_Democrats, TRIM=false}, {SCHEMA_COLUMN=Percent_good_votes_Respect___The_Unity_Coalition, TRIM=false}, {SCHEMA_COLUMN=Percent_good_votes_Peoples_party_for_better_government, TRIM=false}, {SCHEMA_COLUMN=Percent_good_votes_TOTAL_Good_Votes, TRIM=false}, {SCHEMA_COLUMN=TOTAL_Spoils_as_percent_good_votes, TRIM=false}]
Check each row structure against schemafalse
Codificación"US-ASCII"
Split row before fieldfalse
Show Informationfalse
Comentario

							Schema for							tFileInputDelimited_1							:						
									Column																	Key																	Type																	Length																	Precision																	Nullable																	Comment								
CodefalseString4true
BoroughfalseString22true
Number_votes_ConservativesfalseInteger6true
Number_votes_LabourfalseInteger6true
Number_votes_Liberal_DemocratsfalseInteger6true
Number_votes_GreenfalseInteger6true
Number_votes_UKIPfalseInteger6true
Number_votes_BNPfalseInteger5true
Number_votes_Christian_Peoples_AlliancefalseInteger5true
Number_votes_English_DemocratsfalseInteger5true
Number_votes_Respect___The_Unity_CoalitionfalseInteger5true
Number_votes_Peoples_party_for_better_governmentfalseInteger4true
Number_votes_TOTAL_Good_VotesfalseInteger7true
Number_spoils_Uncertain_or_BlankfalseInteger5true
Number_spoils_Voting_for_too_many_candidatesfalseInteger4true
Number_spoils_Writing_a_mark_by_which_the_voter_could_be_identifiedfalseInteger3true
Number_spoils_Lack_of_Official_MarkfalseInteger3true
Number_spoils_TOTAL_SpoilsfalseInteger5true
ElectoratefalseInteger7true
Ballot_papersfalseInteger7true
percent_pollfalseFloat42true
Percent_good_votes_ConservativesfalseFloat42true
Percent_good_votes_LabourfalseFloat42true
Percent_good_votes_Liberal_DemocratsfalseFloat42true
Percent_good_votes_GreenfalseFloat43true
Percent_good_votes_UKIPfalseFloat42true
Percent_good_votes_BNPfalseFloat43true
Percent_good_votes_Christian_Peoples_AlliancefalseFloat32true
Percent_good_votes_English_DemocratsfalseFloat32true
Percent_good_votes_Respect___The_Unity_CoalitionfalseFloat43true
Percent_good_votes_Peoples_party_for_better_governmentfalseFloat32true
Percent_good_votes_TOTAL_Good_VotesfalseInteger3true
TOTAL_Spoils_as_percent_good_votesfalseFloat32true

Original Function Parameters:
									Component:  									tFileInputDelimited

								     															UNIQUE NAME							tFileInputDelimited_2								INPUT(S)							none
								LABEL							europeas_2009								OUTPUT(S)							tFilterRow_2

Component Parameters:
								Properties															Values							
Activatetrue
tStatCatcher Statisticsfalse
File Name/Input Stream"D:/BI/Info BI/BLog/Entrada 14.11/Datos/Elecciones Europeas 2009.csv"
Row Separator"\n"
Field Separator","
Opciones CSVfalse
Header1
Footer0
Limit
Skip empty rowsfalse
Die on errorfalse
Advanced separator(for number)false
Extract lines at randomfalse
Trim all columnfalse
Check column to trim[{SCHEMA_COLUMN=Code, TRIM=false}, {SCHEMA_COLUMN=Authority, TRIM=false}, {SCHEMA_COLUMN=Eligible_Electors, TRIM=false}, {SCHEMA_COLUMN=Verified_Ballots, TRIM=false}, {SCHEMA_COLUMN=Turnout, TRIM=false}, {SCHEMA_COLUMN=Conservative_Party_votes, TRIM=false}, {SCHEMA_COLUMN=The_Labour_Party_votes, TRIM=false}, {SCHEMA_COLUMN=Liberal_Democrats_votes, TRIM=false}, {SCHEMA_COLUMN=The_Green_Party_votes, TRIM=false}, {SCHEMA_COLUMN=United_Kingdom_Independence_Party_votes, TRIM=false}, {SCHEMA_COLUMN=British_National_Party_votes, TRIM=false}, {SCHEMA_COLUMN=Christian_Party_Proclaiming_Christ_s_Lordship_votes, TRIM=false}, {SCHEMA_COLUMN=Jan_Jananayagam_votes, TRIM=false}, {SCHEMA_COLUMN=English_Democrats_Party_votes, TRIM=false}, {SCHEMA_COLUMN=No2EU__Yes_To_Democracy_votes, TRIM=false}, {SCHEMA_COLUMN=Socialist_Labour_Party_votes, TRIM=false}, {SCHEMA_COLUMN=Pro_Democracy__Libertas_eu_votes, TRIM=false}, {SCHEMA_COLUMN=Jury_Team_votes, TRIM=false}, {SCHEMA_COLUMN=Steven_Cheung_votes, TRIM=false}, {SCHEMA_COLUMN=The_Socialist_Party_of_Great_Britain_votes, TRIM=false}, {SCHEMA_COLUMN=Yes_2_Europe_votes, TRIM=false}, {SCHEMA_COLUMN=Sohale_Rahman_votes, TRIM=false}, {SCHEMA_COLUMN=Gene_Alcantara_votes, TRIM=false}, {SCHEMA_COLUMN=Haroon_Saad_votes, TRIM=false}, {SCHEMA_COLUMN=Total_Party_Votes, TRIM=false}, {SCHEMA_COLUMN=Total_Rejected_Votes, TRIM=false}, {SCHEMA_COLUMN=Conservative_Party_percent_good_votes, TRIM=false}, {SCHEMA_COLUMN=The_Labour_Party_percent_good_votes, TRIM=false}, {SCHEMA_COLUMN=Liberal_Democrats_percent_good_votes, TRIM=false}, {SCHEMA_COLUMN=The_Green_Party_percent_good_votes, TRIM=false}, {SCHEMA_COLUMN=United_Kingdom_Independence_Party_percent_good_votes, TRIM=false}, {SCHEMA_COLUMN=British_National_Party_percent_good_votes, TRIM=false}, {SCHEMA_COLUMN=Christian_Party_Proclaiming_Christ_s_Lordship_percent_good_votes, TRIM=false}, {SCHEMA_COLUMN=Jan_Jananayagam_percent_good_votes, TRIM=false}, {SCHEMA_COLUMN=English_Democrats_Party_percent_good_votes, TRIM=false}, {SCHEMA_COLUMN=No2EU__Yes_To_Democracy_percent_good_votes, TRIM=false}, {SCHEMA_COLUMN=Socialist_Labour_Party_percent_good_votes, TRIM=false}, {SCHEMA_COLUMN=Pro_Democracy__Libertas_eu_percent_good_votes, TRIM=false}, {SCHEMA_COLUMN=Jury_Team_percent_good_votes, TRIM=false}, {SCHEMA_COLUMN=Steven_Cheung_percent_good_votes, TRIM=false}, {SCHEMA_COLUMN=The_Socialist_Party_of_Great_Britain_percent_good_votes, TRIM=false}, {SCHEMA_COLUMN=Yes_2_Europe_percent_good_votes, TRIM=false}, {SCHEMA_COLUMN=Sohale_Rahman_percent_good_votes, TRIM=false}, {SCHEMA_COLUMN=Gene_Alcantara_percent_good_votes, TRIM=false}, {SCHEMA_COLUMN=Haroon_Saad_percent_good_votes, TRIM=false}]
Check each row structure against schemafalse
Codificación"US-ASCII"
Split row before fieldfalse
Show Informationfalse
Comentario

							Schema for							tFileInputDelimited_2							:						
									Column																	Key																	Type																	Length																	Precision																	Nullable																	Comment								
CodefalseString4true
AuthorityfalseString20true
Eligible_ElectorsfalseInteger7true
Verified_BallotsfalseInteger7true
TurnoutfalseFloat42true
Conservative_Party_votesfalseInteger6true
The_Labour_Party_votesfalseInteger6true
Liberal_Democrats_votesfalseInteger6true
The_Green_Party_votesfalseInteger6true
United_Kingdom_Independence_Party_votesfalseInteger6true
British_National_Party_votesfalseInteger5true
Christian_Party_Proclaiming_Christ_s_Lordship_votesfalseInteger5true
Jan_Jananayagam_votesfalseInteger5true
English_Democrats_Party_votesfalseInteger5true
No2EU__Yes_To_Democracy_votesfalseInteger5true
Socialist_Labour_Party_votesfalseInteger5true
Pro_Democracy__Libertas_eu_votesfalseInteger4true
Jury_Team_votesfalseInteger4true
Steven_Cheung_votesfalseInteger4true
The_Socialist_Party_of_Great_Britain_votesfalseInteger4true
Yes_2_Europe_votesfalseInteger4true
Sohale_Rahman_votesfalseInteger4true
Gene_Alcantara_votesfalseInteger4true
Haroon_Saad_votesfalseInteger4true
Total_Party_VotesfalseInteger7true
Total_Rejected_VotesfalseInteger5true
Conservative_Party_percent_good_votesfalseFloat42true
The_Labour_Party_percent_good_votesfalseFloat42true
Liberal_Democrats_percent_good_votesfalseFloat42true
The_Green_Party_percent_good_votesfalseFloat42true
United_Kingdom_Independence_Party_percent_good_votesfalseFloat42true
British_National_Party_percent_good_votesfalseFloat43true
Christian_Party_Proclaiming_Christ_s_Lordship_percent_good_votesfalseFloat32true
Jan_Jananayagam_percent_good_votesfalseFloat32true
English_Democrats_Party_percent_good_votesfalseFloat32true
No2EU__Yes_To_Democracy_percent_good_votesfalseFloat32true
Socialist_Labour_Party_percent_good_votesfalseFloat32true
Pro_Democracy__Libertas_eu_percent_good_votesfalseFloat32true
Jury_Team_percent_good_votesfalseFloat32true
Steven_Cheung_percent_good_votesfalseFloat32true
The_Socialist_Party_of_Great_Britain_percent_good_votesfalseFloat32true
Yes_2_Europe_percent_good_votesfalseFloat32true
Sohale_Rahman_percent_good_votesfalseFloat32true
Gene_Alcantara_percent_good_votesfalseFloat32true
Haroon_Saad_percent_good_votesfalseFloat32true

Original Function Parameters:
									Component:  									tFileInputDelimited

								     															UNIQUE NAME							tFileInputDelimited_3								INPUT(S)							none
								LABEL							regionales_2004								OUTPUT(S)							tFilterRow_3

Component Parameters:
								Properties															Values							
Activatetrue
tStatCatcher Statisticsfalse
File Name/Input Stream"D:/BI/Info BI/BLog/Entrada 14.11/Datos/Elecciones Regionales 2004.csv"
Row Separator"\n"
Field Separator","
Opciones CSVfalse
Header1
Footer0
Limit
Skip empty rowsfalse
Die on errorfalse
Advanced separator(for number)false
Extract lines at randomfalse
Trim all columnfalse
Check column to trim" type="Integer" length="4" precision="" nullable="true" comment=""/>            <column name="London_Mayor_1st_choice_Steven_John_NORRIS____Conservative_And_Unionist_Party" key="false" type="Integer" length="6" precision="" nullable="true" comment=""/>            <column name="London_Mayor_1st_choice_Lorna_REID____Independent_Working_Class_Association" key="false" type="Integer" length="4" precision="" nullable="true" comment=""/>            <column name="London_Mayor_1st_choice_TOTAL_Good_Votes" key="false" type="Integer" length="7" precision="" nullable="true" comment=""/>            <column name="London_Mayor_1st_choice_spoils_Uncertain_or_Blank" key="false" type="Integer" length="5" precision="" nullable="true" comment=""/>            <column name="London_Mayor_1st_choice_spoils_Voting_for_too_many_candidates" key="false" type="Integer" length="5" precision="" nullable="true" comment=""/>            <column name="London_Mayor_1st_choice_spoils_Writing_a_mark_by_which_the_voter_could_be_identified" key="false" type="Integer" length="3" precision="" nullable="true" comment=""/>            <column name="London_Mayor_1st_choice_spoils_Lack_of_Official_Mark" key="false" type="Integer" length="3" precision="" nullable="true" comment=""/>            <column name="London_Mayor_1st_choice_spoils_TOTAL_spoils" key="false" type="Integer" length="5" precision="" nullable="true" condon_Mayor_1st_choice_spoils_Writing_a_mark_by_which_the_voter_could_be_identified, TRIM=false}, {SCHEMA_COLUMN=London_Mayor_1st_choice_spoils_Lack_of_Official_Mark, TRIM=false}, {SCHEMA_COLUMN=London_Mayor_1st_choice_spoils_TOTAL_spoils, TRIM=false}, {SCHEMA_COLUMN=London_Mayor_2nd_Choice_Lindsey_Ann_GERMAN___Respect_The_Unity_Coalition__George_Galloway, TRIM=false}, {SCHEMA_COLUMN=London_Mayor_2nd_Choice_Balram_GIDOOMAL_Known_as_Ram____Christian_Peoples_Alliance, TRIM=false}, {SCHEMA_COLUMN=London_Mayor_2nd_Choice_Simon_Henry_Ward_HUGHES___Liberal_Democrats, TRIM=false}, {SCHEMA_COLUMN=London_Mayor_2nd_Choice_Darren_JOHNSON___Green_Party_Candidate, TRIM=false}, {SCHEMA_COLUMN=London_Mayor_2nd_Choice_Julian_Peter_LEPPERT____British_National_Party, TRIM=false}, {SCHEMA_COLUMN=London_Mayor_2nd_Choice_Kenneth_Robert_LIVINGSTONE____The_Labour_Party, TRIM=false}, {SCHEMA_COLUMN=London_Mayor_2nd_Choice_Francis_MALONEY__Known_as_Frank____UK_Independence_Party, TRIM=false}, {SCHEMA_COLUMN=London_Mayor_2nd_Choice_Puvanarani_Tammy_Dr_NAGALINGAM____Ind, TRIM=false}, {SCHEMA_COLUMN=London_Mayor_2nd_Choice_Steven_John_NORRIS____Conservative_And_Unionist_Party, TRIM=false}, {SCHEMA_COLUMN=London_Mayor_2nd_Choice_Lorna_REID____Independent_Working_Class_Association, TRIM=false}, {SCHEMA_COLUMN=London_Mayor_2nd_Choice_TOTAL_Good_Votes, TRIM=false}, {SCHEMA_COLUMN=London_Mayor_2st_choice_spoils_No_valid_first_choice, TRIM=false}, {SCHEMA_COLUMN=London_Mayor_2st_choice_spoils_Uncertain_or_Blank, TRIM=false}, {SCHEMA_COLUMN=London_Mayor_2st_choice_spoils_Voting_for_too_many_candidates, TRIM=false}, {SCHEMA_COLUMN=London_Mayor_2st_choice_spoils_TOTAL_Spoils, TRIM=false}, {SCHEMA_COLUMN=London_Mayor_Assembly_electorate, TRIM=false}, {SCHEMA_COLUMN=London_Mayor___poll__turnout, TRIM=false}, {SCHEMA_COLUMN=London_Member_Alliance_for_Diversity_in_Community_Uppal, TRIM=false}, {SCHEMA_COLUMN=London_Member_British_National_Party, TRIM=false}, {SCHEMA_COLUMN=London_Member_Christian_Peoples_Alliance, TRIM=false}, {SCHEMA_COLUMN=London_Member_Conservative_And_Unionist_Party, TRIM=false}, {SCHEMA_COLUMN=London_Member_The_Green_Party, TRIM=false}, {SCHEMA_COLUMN=London_Member_The_Labour_Party, TRIM=false}, {SCHEMA_COLUMN=London_Member_Liberal_Democrats, TRIM=false}, {SCHEMA_COLUMN=London_Member_Respect_The_Unity_Coalition__George_Galloway, TRIM=false}, {SCHEMA_COLUMN=London_Member_United_Kingdom_Independence_Party, TRIM=false}, {SCHEMA_COLUMN=London_Member_TOTAL_Good_Votes, TRIM=false}, {SCHEMA_COLUMN=London_Member_Spoils_Uncertain_or_Blank, TRIM=false}, {SCHEMA_COLUMN=London_Member_Spoils_Voting_for_too_many_candidates, TRIM=false}, {SCHEMA_COLUMN=London_Member_Spoils_Writing_a_mark_by_which_the_voter_could_be_identified, TRIM=false}, {SCHEMA_COLUMN=London_Member_Spoils_Lack_of_Official_Mark, TRIM=false}, {SCHEMA_COLUMN=London_Member_Spoils_TOTAL_Spoils, TRIM=false}, {SCHEMA_COLUMN=London_Member___poll__turnout, TRIM=false}, {SCHEMA_COLUMN=Constituency_Member_Candidate_1, TRIM=false}, {SCHEMA_COLUMN=Constituency_Member_Candidate_2, TRIM=false}, {SCHEMA_COLUMN=Constituency_Member_Candidate_3, TRIM=false}, {SCHEMA_COLUMN=Constituency_Member_Candidate_4, TRIM=false}, {SCHEMA_COLUMN=Constituency_Member_Candidate_5, TRIM=false}, {SCHEMA_COLUMN=Constituency_Member_Candidate_6, TRIM=false}, {SCHEMA_COLUMN=Constituency_Member_Candidate_7, TRIM=false}, {SCHEMA_COLUMN=Constituency_Member_Candidate_8, TRIM=false}, {SCHEMA_COLUMN=Constituency_Member_Candidate_9, TRIM=false}, {SCHEMA_COLUMN=Constituency_Member_Candidate_10, TRIM=false}, {SCHEMA_COLUMN=Constituency_Member_TOTAL_Good_Votes, TRIM=false}, {SCHEMA_COLUMN=Constituency_Member_Spoils_Uncertain_or_Blank, TRIM=false}, {SCHEMA_COLUMN=Constituency_Member_Spoils_Voting_for_too_many_candidates, TRIM=false}, {SCHEMA_COLUMN=Constituency_Member_Spoils_Writing_a_mark_by_which_the_voter_could_be_identified, TRIM=false}, {SCHEMA_COLUMN=Constituency_Member_Spoils_Lack_of_Official_Mark, TRIM=false}, {SCHEMA_COLUMN=Constituency_Member_Spoils_TOTAL_Spoils, TRIM=false}, {SCHEMA_COLUMN=Constituency_Member_Candidate_11, TRIM=false}, {SCHEMA_COLUMN=Constituency_Member_Candidate_21, TRIM=false}, {SCHEMA_COLUMN=Constituency_Member_Candidate_31, TRIM=false}, {SCHEMA_COLUMN=Constituency_Member_Candidate_41, TRIM=false}, {SCHEMA_COLUMN=Constituency_Member_Candidate_51, TRIM=false}, {SCHEMA_COLUMN=Constituency_Member_Candidate_61, TRIM=false}, {SCHEMA_COLUMN=Constituency_Member_Candidate_71, TRIM=false}, {SCHEMA_COLUMN=Constituency_Member_Candidate_81, TRIM=false}, {SCHEMA_COLUMN=Constituency_Member_Candidate_91, TRIM=false}, {SCHEMA_COLUMN=Constituency_Member_Candidate_101, TRIM=false}]
Check each row structure against schemafalse
Codificación"US-ASCII"
Split row before fieldfalse
Show Informationfalse
Comentario

							Schema for							tFileInputDelimited_3							:						
									Column																	Key																	Type																	Length																	Precision																	Nullable																	Comment								
CodefalseString4true
BoroughfalseString20true
ConstituencyfalseString22true
London_Mayor_1st_choice_Lindsey_Ann_GERMAN___Respect_The_Unity_Coalition__George_GallowayfalseInteger5true
London_Mayor_1st_choice_Balram_GIDOOMAL_Known_as_Ram____Christian_Peoples_AlliancefalseInteger5true
London_Mayor_1st_choice_Simon_Henry_Ward_HUGHES___Liberal_DemocratsfalseInteger6true
London_Mayor_1st_choice_Darren_JOHNSON___Green_Party_CandidatefalseInteger5true
London_Mayor_1st_choice_Julian_Peter_LEPPERT____British_National_PartyfalseInteger5true
London_Mayor_1st_choice_Kenneth_Robert_LIVINGSTONE____The_Labour_PartyfalseInteger6true
London_Mayor_1st_choice_Francis_MALONEY__Known_as_Frank____UK_Independence_PartyfalseInteger6true
London_Mayor_1st_choice_Puvanarani_Tammy_Dr_NAGALINGAM____IndfalseInteger4true
London_Mayor_1st_choice_Steven_John_NORRIS____Conservative_And_Unionist_PartyfalseInteger6true
London_Mayor_1st_choice_Lorna_REID____Independent_Working_Class_AssociationfalseInteger4true
London_Mayor_1st_choice_TOTAL_Good_VotesfalseInteger7true
London_Mayor_1st_choice_spoils_Uncertain_or_BlankfalseInteger5true
London_Mayor_1st_choice_spoils_Voting_for_too_many_candidatesfalseInteger5true
London_Mayor_1st_choice_spoils_Writing_a_mark_by_which_the_voter_could_be_identifiedfalseInteger3true
London_Mayor_1st_choice_spoils_Lack_of_Official_MarkfalseInteger3true
London_Mayor_1st_choice_spoils_TOTAL_spoilsfalseInteger5true
London_Mayor_2nd_Choice_Lindsey_Ann_GERMAN___Respect_The_Unity_Coalition__George_GallowayfalseInteger5true
London_Mayor_2nd_Choice_Balram_GIDOOMAL_Known_as_Ram____Christian_Peoples_AlliancefalseInteger5true
London_Mayor_2nd_Choice_Simon_Henry_Ward_HUGHES___Liberal_DemocratsfalseInteger6true
London_Mayor_2nd_Choice_Darren_JOHNSON___Green_Party_CandidatefalseInteger6true
London_Mayor_2nd_Choice_Julian_Peter_LEPPERT____British_National_PartyfalseInteger5true
London_Mayor_2nd_Choice_Kenneth_Robert_LIVINGSTONE____The_Labour_PartyfalseInteger6true
London_Mayor_2nd_Choice_Francis_MALONEY__Known_as_Frank____UK_Independence_PartyfalseInteger6true
London_Mayor_2nd_Choice_Puvanarani_Tammy_Dr_NAGALINGAM____IndfalseInteger5true
London_Mayor_2nd_Choice_Steven_John_NORRIS____Conservative_And_Unionist_PartyfalseInteger6true
London_Mayor_2nd_Choice_Lorna_REID____Independent_Working_Class_AssociationfalseInteger5true
London_Mayor_2nd_Choice_TOTAL_Good_VotesfalseInteger7true
London_Mayor_2st_choice_spoils_No_valid_first_choicefalseInteger5true
London_Mayor_2st_choice_spoils_Uncertain_or_BlankfalseInteger6true
London_Mayor_2st_choice_spoils_Voting_for_too_many_candidatesfalseInteger4true
London_Mayor_2st_choice_spoils_TOTAL_SpoilsfalseInteger6true
London_Mayor_Assembly_electoratefalseInteger7true
London_Mayor___poll__turnoutfalseFloat42true
London_Member_Alliance_for_Diversity_in_Community_UppalfalseInteger4true
London_Member_British_National_PartyfalseInteger5true
London_Member_Christian_Peoples_AlliancefalseInteger5true
London_Member_Conservative_And_Unionist_PartyfalseInteger6true
London_Member_The_Green_PartyfalseInteger6true
London_Member_The_Labour_PartyfalseInteger6true
London_Member_Liberal_DemocratsfalseInteger6true
London_Member_Respect_The_Unity_Coalition__George_GallowayfalseInteger5true
London_Member_United_Kingdom_Independence_PartyfalseInteger6true
London_Member_TOTAL_Good_VotesfalseInteger7true
London_Member_Spoils_Uncertain_or_BlankfalseInteger5true
London_Member_Spoils_Voting_for_too_many_candidatesfalseInteger5true
London_Member_Spoils_Writing_a_mark_by_which_the_voter_could_be_identifiedfalseInteger3true
London_Member_Spoils_Lack_of_Official_MarkfalseInteger3true
London_Member_Spoils_TOTAL_SpoilsfalseInteger5true
London_Member___poll__turnoutfalseFloat42true
Constituency_Member_Candidate_1falseInteger6true
Constituency_Member_Candidate_2falseInteger6true
Constituency_Member_Candidate_3falseInteger6true
Constituency_Member_Candidate_4falseInteger6true
Constituency_Member_Candidate_5falseInteger6true
Constituency_Member_Candidate_6falseInteger6true
Constituency_Member_Candidate_7falseInteger6true
Constituency_Member_Candidate_8falseString6true
Constituency_Member_Candidate_9falseString4true
Constituency_Member_Candidate_10falseString5true
Constituency_Member_TOTAL_Good_VotesfalseInteger7true
Constituency_Member_Spoils_Uncertain_or_BlankfalseInteger6true
Constituency_Member_Spoils_Voting_for_too_many_candidatesfalseInteger4true
Constituency_Member_Spoils_Writing_a_mark_by_which_the_voter_could_be_identifiedfalseInteger3true
Constituency_Member_Spoils_Lack_of_Official_MarkfalseInteger3true
Constituency_Member_Spoils_TOTAL_SpoilsfalseInteger6true
Constituency_Member_Candidate_11falseString48true
Constituency_Member_Candidate_21falseString43true
Constituency_Member_Candidate_31falseString42true
Constituency_Member_Candidate_41falseString51true
Constituency_Member_Candidate_51falseString47true
Constituency_Member_Candidate_61falseString48true
Constituency_Member_Candidate_71falseString48true
Constituency_Member_Candidate_81falseString31true
Constituency_Member_Candidate_91falseString30true
Constituency_Member_Candidate_101falseString38true

Original Function Parameters:
									Component:  									tFilterRow

								     															UNIQUE NAME							tFilterRow_1								INPUT(S)							tFileInputDelimited_1
								LABEL							eliminar_no_londres								OUTPUT(S)							tMap_1

Component Parameters:
								Properties															Values							
Activatetrue
tStatCatcher Statisticsfalse
Logical operator used to combine conditions&&
Conditions[]
Use advanced modetrue
Avanzado// code sample : use input_row to define the condition. // input_row.columnName1.equals("foo") ||!(input_row.columnName2.equals("bar")) // replace the following expression by your own filter condition StringHandling.LEFT(input_row.Code,2).equals("00")
Show Informationfalse
Comentario

							Schema for							tFilterRow_1							:						
									Column																	Key																	Type																	Length																	Precision																	Nullable																	Comment								
CodefalseString4true
BoroughfalseString22true
Number_votes_ConservativesfalseInteger6true
Number_votes_LabourfalseInteger6true
Number_votes_Liberal_DemocratsfalseInteger6true
Number_votes_GreenfalseInteger6true
Number_votes_UKIPfalseInteger6true
Number_votes_BNPfalseInteger5true
Number_votes_Christian_Peoples_AlliancefalseInteger5true
Number_votes_English_DemocratsfalseInteger5true
Number_votes_Respect___The_Unity_CoalitionfalseInteger5true
Number_votes_Peoples_party_for_better_governmentfalseInteger4true
Number_votes_TOTAL_Good_VotesfalseInteger7true
Number_spoils_Uncertain_or_BlankfalseInteger5true
Number_spoils_Voting_for_too_many_candidatesfalseInteger4true
Number_spoils_Writing_a_mark_by_which_the_voter_could_be_identifiedfalseInteger3true
Number_spoils_Lack_of_Official_MarkfalseInteger3true
Number_spoils_TOTAL_SpoilsfalseInteger5true
ElectoratefalseInteger7true
Ballot_papersfalseInteger7true
percent_pollfalseFloat42true
Percent_good_votes_ConservativesfalseFloat42true
Percent_good_votes_LabourfalseFloat42true
Percent_good_votes_Liberal_DemocratsfalseFloat42true
Percent_good_votes_GreenfalseFloat43true
Percent_good_votes_UKIPfalseFloat42true
Percent_good_votes_BNPfalseFloat43true
Percent_good_votes_Christian_Peoples_AlliancefalseFloat32true
Percent_good_votes_English_DemocratsfalseFloat32true
Percent_good_votes_Respect___The_Unity_CoalitionfalseFloat43true
Percent_good_votes_Peoples_party_for_better_governmentfalseFloat32true
Percent_good_votes_TOTAL_Good_VotesfalseInteger3true
TOTAL_Spoils_as_percent_good_votesfalseFloat32true

Original Function Parameters:
									Component:  									tFilterRow

								     															UNIQUE NAME							tFilterRow_2								INPUT(S)							tFileInputDelimited_2
								LABEL							eliminar_no_londres2								OUTPUT(S)							tMap_2

Component Parameters:
								Properties															Values							
Activatetrue
tStatCatcher Statisticsfalse
Logical operator used to combine conditions&&
Conditions[]
Use advanced modetrue
Avanzado// code sample : use input_row to define the condition. // input_row.columnName1.equals("foo") ||!(input_row.columnName2.equals("bar")) // replace the following expression by your own filter condition StringHandling.LEFT(input_row.Code,2).equals("00")
Show Informationfalse
Comentario

							Schema for							tFilterRow_2							:						
									Column																	Key																	Type																	Length																	Precision																	Nullable																	Comment								
CodefalseString4true
AuthorityfalseString20true
Eligible_ElectorsfalseInteger7true
Verified_BallotsfalseInteger7true
TurnoutfalseFloat42true
Conservative_Party_votesfalseInteger6true
The_Labour_Party_votesfalseInteger6true
Liberal_Democrats_votesfalseInteger6true
The_Green_Party_votesfalseInteger6true
United_Kingdom_Independence_Party_votesfalseInteger6true
British_National_Party_votesfalseInteger5true
Christian_Party_Proclaiming_Christ_s_Lordship_votesfalseInteger5true
Jan_Jananayagam_votesfalseInteger5true
English_Democrats_Party_votesfalseInteger5true
No2EU__Yes_To_Democracy_votesfalseInteger5true
Socialist_Labour_Party_votesfalseInteger5true
Pro_Democracy__Libertas_eu_votesfalseInteger4true
Jury_Team_votesfalseInteger4true
Steven_Cheung_votesfalseInteger4true
The_Socialist_Party_of_Great_Britain_votesfalseInteger4true
Yes_2_Europe_votesfalseInteger4true
Sohale_Rahman_votesfalseInteger4true
Gene_Alcantara_votesfalseInteger4true
Haroon_Saad_votesfalseInteger4true
Total_Party_VotesfalseInteger7true
Total_Rejected_VotesfalseInteger5true
Conservative_Party_percent_good_votesfalseFloat42true
The_Labour_Party_percent_good_votesfalseFloat42true
Liberal_Democrats_percent_good_votesfalseFloat42true
The_Green_Party_percent_good_votesfalseFloat42true
United_Kingdom_Independence_Party_percent_good_votesfalseFloat42true
British_National_Party_percent_good_votesfalseFloat43true
Christian_Party_Proclaiming_Christ_s_Lordship_percent_good_votesfalseFloat32true
Jan_Jananayagam_percent_good_votesfalseFloat32true
English_Democrats_Party_percent_good_votesfalseFloat32true
No2EU__Yes_To_Democracy_percent_good_votesfalseFloat32true
Socialist_Labour_Party_percent_good_votesfalseFloat32true
Pro_Democracy__Libertas_eu_percent_good_votesfalseFloat32true
Jury_Team_percent_good_votesfalseFloat32true
Steven_Cheung_percent_good_votesfalseFloat32true
The_Socialist_Party_of_Great_Britain_percent_good_votesfalseFloat32true
Yes_2_Europe_percent_good_votesfalseFloat32true
Sohale_Rahman_percent_good_votesfalseFloat32true
Gene_Alcantara_percent_good_votesfalseFloat32true
Haroon_Saad_percent_good_votesfalseFloat32true

Original Function Parameters:
									Component:  									tFilterRow

								     															UNIQUE NAME							tFilterRow_3								INPUT(S)							tFileInputDelimited_3
								LABEL							eliminar_no_londres3								OUTPUT(S)							tMap_3

Component Parameters:
								Properties															Values							
Activatetrue
tStatCatcher Statisticsfalse
Logical operator used to combine conditions&&
Conditions[]
Use advanced modetrue
Avanzado// code sample : use input_row to define the condition. // input_row.columnName1.equals("foo") ||!(input_row.columnName2.equals("bar")) // replace the following expression by your own filter condition StringHandling.LEFT(input_row.Code,2).equals("00")
Show Informationfalse
Comentario

							Schema for							tFilterRow_3							:						
									Column																	Key																	Type																	Length																	Precision																	Nullable																	Comment								
CodefalseString4true
BoroughfalseString20true
ConstituencyfalseString22true
London_Mayor_1st_choice_Lindsey_Ann_GERMAN___Respect_The_Unity_Coalition__George_GallowayfalseInteger5true
London_Mayor_1st_choice_Balram_GIDOOMAL_Known_as_Ram____Christian_Peoples_AlliancefalseInteger5true
London_Mayor_1st_choice_Simon_Henry_Ward_HUGHES___Liberal_DemocratsfalseInteger6true
London_Mayor_1st_choice_Darren_JOHNSON___Green_Party_CandidatefalseInteger5true
London_Mayor_1st_choice_Julian_Peter_LEPPERT____British_National_PartyfalseInteger5true
London_Mayor_1st_choice_Kenneth_Robert_LIVINGSTONE____The_Labour_PartyfalseInteger6true
London_Mayor_1st_choice_Francis_MALONEY__Known_as_Frank____UK_Independence_PartyfalseInteger6true
London_Mayor_1st_choice_Puvanarani_Tammy_Dr_NAGALINGAM____IndfalseInteger4true
London_Mayor_1st_choice_Steven_John_NORRIS____Conservative_And_Unionist_PartyfalseInteger6true
London_Mayor_1st_choice_Lorna_REID____Independent_Working_Class_AssociationfalseInteger4true
London_Mayor_1st_choice_TOTAL_Good_VotesfalseInteger7true
London_Mayor_1st_choice_spoils_Uncertain_or_BlankfalseInteger5true
London_Mayor_1st_choice_spoils_Voting_for_too_many_candidatesfalseInteger5true
London_Mayor_1st_choice_spoils_Writing_a_mark_by_which_the_voter_could_be_identifiedfalseInteger3true
London_Mayor_1st_choice_spoils_Lack_of_Official_MarkfalseInteger3true
London_Mayor_1st_choice_spoils_TOTAL_spoilsfalseInteger5true
London_Mayor_2nd_Choice_Lindsey_Ann_GERMAN___Respect_The_Unity_Coalition__George_GallowayfalseInteger5true
London_Mayor_2nd_Choice_Balram_GIDOOMAL_Known_as_Ram____Christian_Peoples_AlliancefalseInteger5true
London_Mayor_2nd_Choice_Simon_Henry_Ward_HUGHES___Liberal_DemocratsfalseInteger6true
London_Mayor_2nd_Choice_Darren_JOHNSON___Green_Party_CandidatefalseInteger6true
London_Mayor_2nd_Choice_Julian_Peter_LEPPERT____British_National_PartyfalseInteger5true
London_Mayor_2nd_Choice_Kenneth_Robert_LIVINGSTONE____The_Labour_PartyfalseInteger6true
London_Mayor_2nd_Choice_Francis_MALONEY__Known_as_Frank____UK_Independence_PartyfalseInteger6true
London_Mayor_2nd_Choice_Puvanarani_Tammy_Dr_NAGALINGAM____IndfalseInteger5true
London_Mayor_2nd_Choice_Steven_John_NORRIS____Conservative_And_Unionist_PartyfalseInteger6true
London_Mayor_2nd_Choice_Lorna_REID____Independent_Working_Class_AssociationfalseInteger5true
London_Mayor_2nd_Choice_TOTAL_Good_VotesfalseInteger7true
London_Mayor_2st_choice_spoils_No_valid_first_choicefalseInteger5true
London_Mayor_2st_choice_spoils_Uncertain_or_BlankfalseInteger6true
London_Mayor_2st_choice_spoils_Voting_for_too_many_candidatesfalseInteger4true
London_Mayor_2st_choice_spoils_TOTAL_SpoilsfalseInteger6true
London_Mayor_Assembly_electoratefalseInteger7true
London_Mayor___poll__turnoutfalseFloat42true
London_Member_Alliance_for_Diversity_in_Community_UppalfalseInteger4true
London_Member_British_National_PartyfalseInteger5true
London_Member_Christian_Peoples_AlliancefalseInteger5true
London_Member_Conservative_And_Unionist_PartyfalseInteger6true
London_Member_The_Green_PartyfalseInteger6true
London_Member_The_Labour_PartyfalseInteger6true
London_Member_Liberal_DemocratsfalseInteger6true
London_Member_Respect_The_Unity_Coalition__George_GallowayfalseInteger5true
London_Member_United_Kingdom_Independence_PartyfalseInteger6true
London_Member_TOTAL_Good_VotesfalseInteger7true
London_Member_Spoils_Uncertain_or_BlankfalseInteger5true
London_Member_Spoils_Voting_for_too_many_candidatesfalseInteger5true
London_Member_Spoils_Writing_a_mark_by_which_the_voter_could_be_identifiedfalseInteger3true
London_Member_Spoils_Lack_of_Official_MarkfalseInteger3true
London_Member_Spoils_TOTAL_SpoilsfalseInteger5true
London_Member___poll__turnoutfalseFloat42true
Constituency_Member_Candidate_1falseInteger6true
Constituency_Member_Candidate_2falseInteger6true
Constituency_Member_Candidate_3falseInteger6true
Constituency_Member_Candidate_4falseInteger6true
Constituency_Member_Candidate_5falseInteger6true
Constituency_Member_Candidate_6falseInteger6true
Constituency_Member_Candidate_7falseInteger6true
Constituency_Member_Candidate_8falseString6true
Constituency_Member_Candidate_9falseString4true
Constituency_Member_Candidate_10falseString5true
Constituency_Member_TOTAL_Good_VotesfalseInteger7true
Constituency_Member_Spoils_Uncertain_or_BlankfalseInteger6true
Constituency_Member_Spoils_Voting_for_too_many_candidatesfalseInteger4true
Constituency_Member_Spoils_Writing_a_mark_by_which_the_voter_could_be_identifiedfalseInteger3true
Constituency_Member_Spoils_Lack_of_Official_MarkfalseInteger3true
Constituency_Member_Spoils_TOTAL_SpoilsfalseInteger6true
Constituency_Member_Candidate_11falseString48true
Constituency_Member_Candidate_21falseString43true
Constituency_Member_Candidate_31falseString42true
Constituency_Member_Candidate_41falseString51true
Constituency_Member_Candidate_51falseString47true
Constituency_Member_Candidate_61falseString48true
Constituency_Member_Candidate_71falseString48true
Constituency_Member_Candidate_81falseString31true
Constituency_Member_Candidate_91falseString30true
Constituency_Member_Candidate_101falseString38true

Original Function Parameters:
									Component:  									tMysqlOutput

								     															UNIQUE NAME							tMysqlOutput_1								INPUT(S)							tUnite_1
								LABEL							Actualiza_DWH_POLITICA								OUTPUT(S)							none

Component Parameters:
								Properties															Values							
Activatetrue
tStatCatcher Statisticsfalse
Use an existing connectionfalse
Host"pcserver7"
Port"3306"
Base de Datos"london"
Username"root"
Password******
Table"dwh_politica"
Action on tableDROP_IF_EXISTS_AND_CREATE
Action on dataUPDATE_OR_INSERT
Schema
Die on errorfalse
Additional JDBC Parameters"noDatetimeStringSync=true"
Codificación"ISO-8859-15"
Commit every10000
Columnas adicionales[]
Use field optionsfalse
Use Hint Optionsfalse
Enable debug modefalse
Show Informationfalse
Comentario

							Schema for							tMysqlOutput_1							:						
									Column																	Key																	Type																	Length																	Precision																	Nullable																	Comment								
Area_idtrueString4true
Anyo_idtrueString4true
TipotrueString10true
N_Conservadores_VotosfalseInteger6true
N_Laboristas_VotosfalseInteger6true
N_Liberales_VotosfalseInteger6true
N_Verdes_VotosfalseInteger6true
N_UK_Independ_VotosfalseInteger6true
N_Bristish_National_Party_VotosfalseInteger6true
N_Cristian_Party_VotosfalseInteger6true
N_Otros_VotosfalseInteger6true
N_Total_Votos_CorrectosfalseInteger6true
N_Total_Votos_NulosfalseInteger5true
N_ElectoradofalseInteger7true
N_Votos_EmitidosfalseInteger7true
P_Porcentaje_ParticipacionfalseFloat42true

Original Function Parameters:
									Component:  									tUnite

								     															UNIQUE NAME							tUnite_1								INPUT(S)							tFilterRow_3,  tMap_3
								LABEL							__UNIQUE_NAME__								OUTPUT(S)							tMysqlOutput_1

Component Parameters:
								Properties															Values							
Activatetrue
tStatCatcher Statisticsfalse
Show Informationfalse
Comentario

							Schema for							tUnite_1							:						
									Column																	Key																	Type																	Length																	Precision																	Nullable																	Comment								
Area_idtrueString4true
Anyo_idtrueString4true
TipotrueString10true
N_Conservadores_VotosfalseInteger6true
N_Laboristas_VotosfalseInteger6true
N_Liberales_VotosfalseInteger6true
N_Verdes_VotosfalseInteger6true
N_UK_Independ_VotosfalseInteger6true
N_Bristish_National_Party_VotosfalseInteger6true
N_Cristian_Party_VotosfalseInteger6true
N_Otros_VotosfalseInteger6true
N_Total_Votos_CorrectosfalseInteger6true
N_Total_Votos_NulosfalseInteger5true
N_ElectoradofalseInteger7true
N_Votos_EmitidosfalseInteger7true
P_Porcentaje_ParticipacionfalseFloat42true

Original Function Parameters:
									Component:  									tMap

								     															UNIQUE NAME							tMap_1								INPUT(S)							tFilterRow_1
								LABEL							__UNIQUE_NAME__								OUTPUT(S)							tUnite_1

No image available



Component Parameters:

								Properties
							
								Values
							
tStatCatcher Statistics
false
Mapping links display as: 
AUTO
Temp data directory path: 
Max buffer size (nb of rows): 
2000000
Show Information
false
Comentario


				Mapper table for
				tMap_1
				(
				input
				):
			

								Mapper table Properties(
								row2
								):
							

										Properties
									
										Values
									

										Name
									row2

										Matching-mode
									UNIQUE_MATCH

										isMinimized
									false

										isReject
									false

										isRejectInnerJoin
									false

										isInnerJoin
									false


								Metadata Table Entries(
								row2
								):
							

										Name
									
										Type
									
										Expression
									
										isNullable
									
CodeStringtrue
BoroughStringtrue
Number_votes_ConservativesIntegertrue
Number_votes_LabourIntegertrue
Number_votes_Liberal_DemocratsIntegertrue
Number_votes_GreenIntegertrue
Number_votes_UKIPIntegertrue
Number_votes_BNPIntegertrue
Number_votes_Christian_Peoples_AllianceIntegertrue
Number_votes_English_DemocratsIntegertrue
Number_votes_Respect___The_Unity_CoalitionIntegertrue
Number_votes_Peoples_party_for_better_governmentIntegertrue
Number_votes_TOTAL_Good_VotesIntegertrue
Number_spoils_Uncertain_or_BlankIntegertrue
Number_spoils_Voting_for_too_many_candidatesIntegertrue
Number_spoils_Writing_a_mark_by_which_the_voter_could_be_identifiedIntegertrue
Number_spoils_Lack_of_Official_MarkIntegertrue
Number_spoils_TOTAL_SpoilsIntegertrue
ElectorateIntegertrue
Ballot_papersIntegertrue
percent_pollFloattrue
Percent_good_votes_ConservativesFloattrue
Percent_good_votes_LabourFloattrue
Percent_good_votes_Liberal_DemocratsFloattrue
Percent_good_votes_GreenFloattrue
Percent_good_votes_UKIPFloattrue
Percent_good_votes_BNPFloattrue
Percent_good_votes_Christian_Peoples_AllianceFloattrue
Percent_good_votes_English_DemocratsFloattrue
Percent_good_votes_Respect___The_Unity_CoalitionFloattrue
Percent_good_votes_Peoples_party_for_better_governmentFloattrue
Percent_good_votes_TOTAL_Good_VotesIntegertrue
TOTAL_Spoils_as_percent_good_votesFloattrue


								Constraint Table Entries(
								row2
								):
							

										Name
									
										Type
									
										Expression
									
										isNullable
									


				Mapper table for
				tMap_1
				(
				output
				):
			

								Mapper table Properties(
								resultados
								):
							

										Properties
									
										Values
									

										Name
									resultados

										Matching-mode
									

										isMinimized
									false

										isReject
									false

										isRejectInnerJoin
									false

										isInnerJoin
									false


								Metadata Table Entries(
								resultados
								):
							

										Name
									
										Type
									
										Expression
									
										isNullable
									
Area_idStringrow2.Code true
Anyo_idString"2004"true
TipoString"EUROPEAS"true
N_Conservadores_VotosIntegerrow2.Number_votes_Conservatives true
N_Laboristas_VotosIntegerrow2.Number_votes_Labour true
N_Liberales_VotosIntegerrow2.Number_votes_Liberal_Democrats true
N_Verdes_VotosIntegerrow2.Number_votes_Green true
N_UK_Independ_VotosIntegerrow2.Number_votes_UKIPtrue
N_Bristish_National_Party_VotosIntegerrow2.Number_votes_BNPtrue
N_Cristian_Party_VotosInteger row2.Number_votes_Christian_Peoples_Alliancetrue
N_Otros_VotosIntegerrow2.Number_votes_English_Democrats + row2.Number_votes_Respect___The_Unity_Coalition + row2.Number_votes_Peoples_party_for_better_government  true
N_Total_Votos_CorrectosIntegerrow2.Number_votes_TOTAL_Good_Votes true
N_Total_Votos_NulosIntegerrow2.Number_spoils_TOTAL_Spoils true
N_ElectoradoIntegerrow2.Electorate true
N_Votos_EmitidosIntegerrow2.Ballot_papers true
P_Porcentaje_ParticipacionFloatrow2.percent_poll true


								Constraint Table Entries(
								resultados
								):
							

										Name
									
										Type
									
										Expression
									
										isNullable
									


				Mapper table for
				tMap_1
				(
				var
				):
			

								Mapper table Properties(
								Var
								):
							

										Properties
									
										Values
									

										Name
									Var

										Matching-mode
									

										isMinimized
									true

										isReject
									false

										isRejectInnerJoin
									false

										isInnerJoin
									false


								Metadata Table Entries(
								Var
								):
							

										Name
									
										Type
									
										Expression
									
										isNullable
									


								Constraint Table Entries(
								Var
								):
							

										Name
									
										Type
									
										Expression
									
										isNullable
									

									Component:  									tMap

								     															UNIQUE NAME							tMap_2								INPUT(S)							tFilterRow_2,  tMap_2
								LABEL							__UNIQUE_NAME__								OUTPUT(S)							tUnite_1

No image available



Component Parameters:

								Properties
							
								Values
							
tStatCatcher Statistics
false
Mapping links display as: 
AUTO
Temp data directory path: 
Max buffer size (nb of rows): 
2000000
Show Information
false
Comentario


				Mapper table for
				tMap_2
				(
				input
				):
			

								Mapper table Properties(
								row4
								):
							

										Properties
									
										Values
									

										Name
									row4

										Matching-mode
									UNIQUE_MATCH

										isMinimized
									false

										isReject
									false

										isRejectInnerJoin
									false

										isInnerJoin
									false


								Metadata Table Entries(
								row4
								):
							

										Name
									
										Type
									
										Expression
									
										isNullable
									
CodeStringtrue
AuthorityStringtrue
Eligible_ElectorsIntegertrue
Verified_BallotsIntegertrue
TurnoutFloattrue
Conservative_Party_votesIntegertrue
The_Labour_Party_votesIntegertrue
Liberal_Democrats_votesIntegertrue
The_Green_Party_votesIntegertrue
United_Kingdom_Independence_Party_votesIntegertrue
British_National_Party_votesIntegertrue
Christian_Party_Proclaiming_Christ_s_Lordship_votesIntegertrue
Jan_Jananayagam_votesIntegertrue
English_Democrats_Party_votesIntegertrue
No2EU__Yes_To_Democracy_votesIntegertrue
Socialist_Labour_Party_votesIntegertrue
Pro_Democracy__Libertas_eu_votesIntegertrue
Jury_Team_votesIntegertrue
Steven_Cheung_votesIntegertrue
The_Socialist_Party_of_Great_Britain_votesIntegertrue
Yes_2_Europe_votesIntegertrue
Sohale_Rahman_votesIntegertrue
Gene_Alcantara_votesIntegertrue
Haroon_Saad_votesIntegertrue
Total_Party_VotesIntegertrue
Total_Rejected_VotesIntegertrue
Conservative_Party_percent_good_votesFloattrue
The_Labour_Party_percent_good_votesFloattrue
Liberal_Democrats_percent_good_votesFloattrue
The_Green_Party_percent_good_votesFloattrue
United_Kingdom_Independence_Party_percent_good_votesFloattrue
British_National_Party_percent_good_votesFloattrue
Christian_Party_Proclaiming_Christ_s_Lordship_percent_good_votesFloattrue
Jan_Jananayagam_percent_good_votesFloattrue
English_Democrats_Party_percent_good_votesFloattrue
No2EU__Yes_To_Democracy_percent_good_votesFloattrue
Socialist_Labour_Party_percent_good_votesFloattrue
Pro_Democracy__Libertas_eu_percent_good_votesFloattrue
Jury_Team_percent_good_votesFloattrue
Steven_Cheung_percent_good_votesFloattrue
The_Socialist_Party_of_Great_Britain_percent_good_votesFloattrue
Yes_2_Europe_percent_good_votesFloattrue
Sohale_Rahman_percent_good_votesFloattrue
Gene_Alcantara_percent_good_votesFloattrue
Haroon_Saad_percent_good_votesFloattrue


								Constraint Table Entries(
								row4
								):
							

										Name
									
										Type
									
										Expression
									
										isNullable
									


				Mapper table for
				tMap_2
				(
				output
				):
			

								Mapper table Properties(
								resultados2
								):
							

										Properties
									
										Values
									

										Name
									resultados2

										Matching-mode
									

										isMinimized
									false

										isReject
									false

										isRejectInnerJoin
									false

										isInnerJoin
									false


								Metadata Table Entries(
								resultados2
								):
							

										Name
									
										Type
									
										Expression
									
										isNullable
									
Area_idStringrow4.Code true
Anyo_idString"2009"true
TipoString"EUROPEAS"true
N_Conservadores_VotosIntegerrow4.Conservative_Party_votes true
N_Laboristas_VotosIntegerrow4.The_Labour_Party_votes true
N_Liberales_VotosIntegerrow4.Liberal_Democrats_votes true
N_Verdes_VotosIntegerrow4.The_Green_Party_votes true
N_UK_Independ_VotosIntegerrow4.United_Kingdom_Independence_Party_votestrue
N_Bristish_National_Party_VotosIntegerrow4.British_National_Party_votestrue
N_Cristian_Party_VotosIntegerrow4.Christian_Party_Proclaiming_Christ_s_Lordship_votestrue
N_Otros_VotosIntegerrow4.Jan_Jananayagam_votes + row4.English_Democrats_Party_votes + row4.No2EU__Yes_To_Democracy_votes + row4.Socialist_Labour_Party_votes + row4.Pro_Democracy__Libertas_eu_votes + row4.Jury_Team_votes + row4.Steven_Cheung_votes + row4.The_Socialist_Party_of_Great_Britain_votes + row4.Yes_2_Europe_votes + row4.Sohale_Rahman_votes + row4.Gene_Alcantara_votes + row4.Haroon_Saad_votes  true
N_Total_Votos_CorrectosIntegerrow4.Total_Party_Votes true
N_Total_Votos_NulosIntegerrow4.Total_Rejected_Votes true
N_ElectoradoIntegerrow4.Eligible_Electors true
N_Votos_EmitidosIntegerrow4.Verified_Ballots true
P_Porcentaje_ParticipacionFloat row4.Turnout true


								Constraint Table Entries(
								resultados2
								):
							

										Name
									
										Type
									
										Expression
									
										isNullable
									


				Mapper table for
				tMap_2
				(
				var
				):
			

								Mapper table Properties(
								Var
								):
							

										Properties
									
										Values
									

										Name
									Var

										Matching-mode
									

										isMinimized
									true

										isReject
									false

										isRejectInnerJoin
									false

										isInnerJoin
									false


								Metadata Table Entries(
								Var
								):
							

										Name
									
										Type
									
										Expression
									
										isNullable
									


								Constraint Table Entries(
								Var
								):
							

										Name
									
										Type
									
										Expression
									
										isNullable
									

									Component:  									tMap

								     															UNIQUE NAME							tMap_3								INPUT(S)							tFilterRow_3,  tMap_3
								LABEL							__UNIQUE_NAME__								OUTPUT(S)							tUnite_1

No image available



Component Parameters:

								Properties
							
								Values
							
tStatCatcher Statistics
false
Mapping links display as: 
AUTO
Temp data directory path: 
Max buffer size (nb of rows): 
2000000
Show Information
false
Comentario


				Mapper table for
				tMap_3
				(
				input
				):
			

								Mapper table Properties(
								row7
								):
							

										Properties
									
										Values
									

										Name
									row7

										Matching-mode
									UNIQUE_MATCH

										isMinimized
									false

										isReject
									false

										isRejectInnerJoin
									false

										isInnerJoin
									false


								Metadata Table Entries(
								row7
								):
							

										Name
									
										Type
									
										Expression
									
										isNullable
									
CodeStringtrue
BoroughStringtrue
ConstituencyStringtrue
London_Mayor_1st_choice_Lindsey_Ann_GERMAN___Respect_The_Unity_Coalition__George_GallowayIntegertrue
London_Mayor_1st_choice_Balram_GIDOOMAL_Known_as_Ram____Christian_Peoples_AllianceIntegertrue
London_Mayor_1st_choice_Simon_Henry_Ward_HUGHES___Liberal_DemocratsIntegertrue
London_Mayor_1st_choice_Darren_JOHNSON___Green_Party_CandidateIntegertrue
London_Mayor_1st_choice_Julian_Peter_LEPPERT____British_National_PartyIntegertrue
London_Mayor_1st_choice_Kenneth_Robert_LIVINGSTONE____The_Labour_PartyIntegertrue
London_Mayor_1st_choice_Francis_MALONEY__Known_as_Frank____UK_Independence_PartyIntegertrue
London_Mayor_1st_choice_Puvanarani_Tammy_Dr_NAGALINGAM____IndIntegertrue
London_Mayor_1st_choice_Steven_John_NORRIS____Conservative_And_Unionist_PartyIntegertrue
London_Mayor_1st_choice_Lorna_REID____Independent_Working_Class_AssociationIntegertrue
London_Mayor_1st_choice_TOTAL_Good_VotesIntegertrue
London_Mayor_1st_choice_spoils_Uncertain_or_BlankIntegertrue
London_Mayor_1st_choice_spoils_Voting_for_too_many_candidatesIntegertrue
London_Mayor_1st_choice_spoils_Writing_a_mark_by_which_the_voter_could_be_identifiedIntegertrue
London_Mayor_1st_choice_spoils_Lack_of_Official_MarkIntegertrue
London_Mayor_1st_choice_spoils_TOTAL_spoilsIntegertrue
London_Mayor_2nd_Choice_Lindsey_Ann_GERMAN___Respect_The_Unity_Coalition__George_GallowayIntegertrue
London_Mayor_2nd_Choice_Balram_GIDOOMAL_Known_as_Ram____Christian_Peoples_AllianceIntegertrue
London_Mayor_2nd_Choice_Simon_Henry_Ward_HUGHES___Liberal_DemocratsIntegertrue
London_Mayor_2nd_Choice_Darren_JOHNSON___Green_Party_CandidateIntegertrue
London_Mayor_2nd_Choice_Julian_Peter_LEPPERT____British_National_PartyIntegertrue
London_Mayor_2nd_Choice_Kenneth_Robert_LIVINGSTONE____The_Labour_PartyIntegertrue
London_Mayor_2nd_Choice_Francis_MALONEY__Known_as_Frank____UK_Independence_PartyIntegertrue
London_Mayor_2nd_Choice_Puvanarani_Tammy_Dr_NAGALINGAM____IndIntegertrue
London_Mayor_2nd_Choice_Steven_John_NORRIS____Conservative_And_Unionist_PartyIntegertrue
London_Mayor_2nd_Choice_Lorna_REID____Independent_Working_Class_AssociationIntegertrue
London_Mayor_2nd_Choice_TOTAL_Good_VotesIntegertrue
London_Mayor_2st_choice_spoils_No_valid_first_choiceIntegertrue
London_Mayor_2st_choice_spoils_Uncertain_or_BlankIntegertrue
London_Mayor_2st_choice_spoils_Voting_for_too_many_candidatesIntegertrue
London_Mayor_2st_choice_spoils_TOTAL_SpoilsIntegertrue
London_Mayor_Assembly_electorateIntegertrue
London_Mayor___poll__turnoutFloattrue
London_Member_Alliance_for_Diversity_in_Community_UppalIntegertrue
London_Member_British_National_PartyIntegertrue
London_Member_Christian_Peoples_AllianceIntegertrue
London_Member_Conservative_And_Unionist_PartyIntegertrue
London_Member_The_Green_PartyIntegertrue
London_Member_The_Labour_PartyIntegertrue
London_Member_Liberal_DemocratsIntegertrue
London_Member_Respect_The_Unity_Coalition__George_GallowayIntegertrue
London_Member_United_Kingdom_Independence_PartyIntegertrue
London_Member_TOTAL_Good_VotesIntegertrue
London_Member_Spoils_Uncertain_or_BlankIntegertrue
London_Member_Spoils_Voting_for_too_many_candidatesIntegertrue
London_Member_Spoils_Writing_a_mark_by_which_the_voter_could_be_identifiedIntegertrue
London_Member_Spoils_Lack_of_Official_MarkIntegertrue
London_Member_Spoils_TOTAL_SpoilsIntegertrue
London_Member___poll__turnoutFloattrue
Constituency_Member_Candidate_1Integertrue
Constituency_Member_Candidate_2Integertrue
Constituency_Member_Candidate_3Integertrue
Constituency_Member_Candidate_4Integertrue
Constituency_Member_Candidate_5Integertrue
Constituency_Member_Candidate_6Integertrue
Constituency_Member_Candidate_7Integertrue
Constituency_Member_Candidate_8Stringtrue
Constituency_Member_Candidate_9Stringtrue
Constituency_Member_Candidate_10Stringtrue
Constituency_Member_TOTAL_Good_VotesIntegertrue
Constituency_Member_Spoils_Uncertain_or_BlankIntegertrue
Constituency_Member_Spoils_Voting_for_too_many_candidatesIntegertrue
Constituency_Member_Spoils_Writing_a_mark_by_which_the_voter_could_be_identifiedIntegertrue
Constituency_Member_Spoils_Lack_of_Official_MarkIntegertrue
Constituency_Member_Spoils_TOTAL_SpoilsIntegertrue
Constituency_Member_Candidate_11Stringtrue
Constituency_Member_Candidate_21Stringtrue
Constituency_Member_Candidate_31Stringtrue
Constituency_Member_Candidate_41Stringtrue
Constituency_Member_Candidate_51Stringtrue
Constituency_Member_Candidate_61Stringtrue
Constituency_Member_Candidate_71Stringtrue
Constituency_Member_Candidate_81Stringtrue
Constituency_Member_Candidate_91Stringtrue
Constituency_Member_Candidate_101Stringtrue


								Constraint Table Entries(
								row7
								):
							

										Name
									
										Type
									
										Expression
									
										isNullable
									


				Mapper table for
				tMap_3
				(
				output
				):
			

								Mapper table Properties(
								locales_2004
								):
							

										Properties
									
										Values
									

										Name
									locales_2004

										Matching-mode
									

										isMinimized
									false

										isReject
									false

										isRejectInnerJoin
									false

										isInnerJoin
									false


								Metadata Table Entries(
								locales_2004
								):
							

										Name
									
										Type
									
										Expression
									
										isNullable
									
Area_idStringrow7.Code true
Anyo_idString"2004"true
TipoString"REGIONALES"true
N_Conservadores_VotosIntegerrow7.London_Member_Conservative_And_Unionist_Party true
N_Laboristas_VotosIntegerrow7.London_Member_The_Labour_Party true
N_Liberales_VotosIntegerrow7.London_Member_Liberal_Democrats true
N_Verdes_VotosIntegerrow7.London_Member_The_Green_Party true
N_UK_Independ_VotosIntegerrow7.London_Member_United_Kingdom_Independence_Party true
N_Bristish_National_Party_VotosIntegerrow7.London_Member_British_National_Party true
N_Cristian_Party_VotosIntegerrow7.London_Member_Christian_Peoples_Alliance true
N_Otros_VotosIntegerrow7.London_Member_Alliance_for_Diversity_in_Community_Uppal  +  row7.London_Member_Respect_The_Unity_Coalition__George_Galloway true
N_Total_Votos_CorrectosIntegerrow7.London_Member_TOTAL_Good_Votes true
N_Total_Votos_NulosIntegerrow7.London_Member_Spoils_TOTAL_Spoils true
N_ElectoradoIntegerrow7.London_Mayor_Assembly_electorate true
N_Votos_EmitidosIntegerrow7.London_Member_TOTAL_Good_Votes  +  row7.London_Member_Spoils_TOTAL_Spoils true
P_Porcentaje_ParticipacionFloatrow7.London_Member___poll__turnout true


								Constraint Table Entries(
								locales_2004
								):
							

										Name
									
										Type
									
										Expression
									
										isNullable
									


				Mapper table for
				tMap_3
				(
				var
				):
			

								Mapper table Properties(
								Var
								):
							

										Properties
									
										Values
									

										Name
									Var

										Matching-mode
									

										isMinimized
									true

										isReject
									false

										isRejectInnerJoin
									false

										isInnerJoin
									false


								Metadata Table Entries(
								Var
								):
							

										Name
									
										Type
									
										Expression
									
										isNullable
									


								Constraint Table Entries(
								Var
								):
							

										Name
									
										Type
									
										Expression
									
										isNullable