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.
Watch the recorded webinar!
Create systems and workflow to manage clean data ingestion and data transformation.
Introduction to Talend Open Studio for Data Integration.
Test drive Talend's enterprise products.