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

 

Highlighted
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
IF

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Enabling Data Governance

Learn how to enable Data Governance

Watch Now

The Definitive Guide to Government Data Quality

Take a peek at the definitive guide to Government Data Quality

Read