Write a file after another one

[Anonymous]

Hi !

I am really new in Talend ETL and i have a problem :

 I have two stock files : 

File one :

Ref Stock

A 10

B 56

C 78

...

File Two :

Ref Stock

HJ 89

LO 36

...

I want to merge them into one file with :

Ref Stock

A 10

...
HJ 89

...

These files are with 5.000 and 8.000 rows...

I tried with Unite and Tmap but it's not really successfull....

Thank you really for your help, i appreciate it.

(Sorry for my english)

Côme

[cmendels]

Can you show us the schemas of your input files and how you set up your job?

[Anonymous]

I'm pretty sure you will gasp when you see it !

Thank you for your reply.

Côme

[mks02]

is there any delimited in both files? If yes, you can use below approach:

Flow 1: tFileInputDelimited -- tFileoutputDelimited

Flow 2: tFileInputDelimited2 -- tFileoutputDelimited   (Append mode)

It'll write both files in output.

[Anonymous]

Thank you for your help,

I think it's on the good way, but i have a little problem,

why the out csv is like this ?

Sans titre.png

[mks02]

The file you are using is not compatible with MS excel. Just open this in notepad++ and do check, if the data is in correct format with delimiter. 

[Anonymous]

Yes, i tried but without success...