Problem: multiples datas importation in a intermediate table - tMap

Anonymous — Tue, 27 Mar 2018 11:10:34 GMT

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-definitifs-du-1er-tour-1/20170427-100131/Presidentielle_2017_Resultats_Tour_1_c.xls) 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.

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

Anonymous — Tue, 27 Mar 2018 13:38:35 GMT

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

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

Anonymous — Tue, 27 Mar 2018 14:14:18 GMT

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

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

Problem: multiples datas importation in a intermediate table - tMap

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

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