Problem: multiples datas importation in a intermediate table - tMap

[Anonymous]

Hi,

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.

[Anonymous]

Hi,

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.

Cheers!

Gatha

[Anonymous]

I want to do values in candidat_elections for election_id. Actually it's "null" it should not be that