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.

Highlighted
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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Introduction to Talend Open Studio for Data Quality

Find out about Talend Open Studio for Data Quality

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