I am novice on Talend. For an exercice i need to integrate data from an excel file (https://www.data.gouv.fr/s/resources/election-presidentielle-des-23-avril-et-7-mai-2017-resultats-de...) to a database PostgreSQL.
Here the system information :
Database: PostGreSQL + PostGIS (for the table "départements")
Tools for Database: pgAdmin 4
Version PostgreSQL: 9.6 and 10
Schéma of DataBase:
Data Sources: Excel File from data.gouv.fr (xls)
Data sources Géométrique Départements: "départements" in GeoJson before conversion in Shapefile, from https://github.com/gregoiredavid/france-geojson.
What I managed to do in 2 others jobs :
Transform of colonn candidats scattered (tSplitRow) in line departement and import it in the table candidat.
Import the results of elections by "départements" (bind between "elections" and "departements").
What I did not manage to do:
Import and bind the "candidats" to the "élections" by the table "candidats_elections" with the number of "voix" associated.
I have the column of cells elections_id it is "null"
Here the job
and the tMap
Thx for your help.
PS : Sorry for the traduction, i'm French and not good in English.
I am still trying to understand the problem you want to solve.
You want to have some values in election_id which you are not getting now?
Or What do you want to do?
I didn't get that.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to enable Data Governance
Take a peek at the definitive guide to Government Data Quality