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

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads