topic Re: Write a file after another one in Talend Studio

Write a file after another one

Anonymous — Sat, 16 Nov 2024 03:19:05 GMT

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

Re: Write a file after another one

cmendels — Mon, 10 Feb 2020 17:52:43 GMT

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

Re: Write a file after another one

Anonymous — Tue, 11 Feb 2020 08:59:57 GMT

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

Thank you for your reply.

Côme

Re: Write a file after another one

mks02 — Tue, 11 Feb 2020 10:30:12 GMT

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.

Re: Write a file after another one

Anonymous — Tue, 11 Feb 2020 10:47:41 GMT

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

Re: Write a file after another one

mks02 — Wed, 12 Feb 2020 09:22:12 GMT

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.

Re: Write a file after another one

Anonymous — Thu, 13 Feb 2020 15:53:47 GMT

Yes, i tried but without success...