Problem: multiples datas importation in a intermediate table - tMap

One Star

Problem: multiples datas importation in a intermediate table - tMap

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:

table.JPG

Data Sources: Excel File from data.gouv.fr (xls)

source_xslx.JPG

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"

data.JPG

Here the job

vue01.JPG

and the tMap

vue02.JPG

Thx for your help.

PS : Sorry for the traduction, i'm French and not good in English.

Seven Stars

Re: Problem: multiples datas importation in a intermediate table - tMap

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

 

One Star

Re: Problem: multiples datas importation in a intermediate table - tMap

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