How to multiple files common key own column into unique file all columns

iztoogood — Sat, 16 Nov 2024 02:21:29 GMT

Can any one can give me an advice to deal with this issue...

il have multiple files (more than 10)

each of them have a key but not exhaustive.... and its own column

i would like to merge all of them into a unique fiel with all columns.

here is an example of my source files :

.---+------.
|tLogRow_1 |
|=--+-----=|
|key|col120|
|=--+-----=|
|1  |A     |
|2  |B     |
|3  |C     |
|5  |E     |
'---+------'

.---+------.
|tLogRow_2 |
|=--+-----=|
|key|col121|
|=--+-----=|
|1  |W     |
|2  |X     |
|3  |Y     |
|4  |Z     |
'---+------'

.---+------.
|tLogRow_3 |
|=--+-----=|
|key|col123|
|=--+-----=|
|1  |R     |
|2  |S     |
|3  |T     |
|6  |U     |
'---+------'

here is the traget file wanted

.---+------+------+------.
|        tLogRow         |
|=--+-----=+-----=+-----=|
|key|col120|col121|col123|
|=--+-----=+-----=+-----=|
|1  |A     |W     |R     |
|2  |B     |X     |S     |
|3  |C     |Y     |T     |
|4  |null  |Z     |null  |
|5  |E     |null  |null  |
|6  |null  |null  |U     |
'---+------+-----+-------'

thanks in advance for your help

Re: How to multiple files common key own column into unique file all columns

iztoogood — Sat, 23 May 2020 11:09:14 GMT

i have found an ugly solution....

begining with a fileList to get an exhaustiv list of key from all files,

then loading each files linked into a tMap

... i would prefer a loop or a iteration instead of loading them each "manually"

2020-05-23 11_49_59-Talend Cloud Data Integration (7.3.1.20200219_1130) _ BAYARD (Connexion_ BAYARD).png

topic Re: How to multiple files common key own column into unique file all columns in Talend Studio

How to multiple files common key own column into unique file all columns

Re: How to multiple files common key own column into unique file all columns