topic Split File group by... in Talend Studio

Split File group by...

Anonymous — Sat, 16 Nov 2024 13:43:56 GMT

Hello,
I have to split a delimited file containing data like :

A;data1
A;data2
A;data3
B;data4
B;data5
I want to split this file to have 2 files (names A.csv and B.csv) containing :
File A.csv :
data1
data2
data3
and
File B.csv :
data4
data5

Someone can help ? Thank U in advance

Re: Split File group by...

Anonymous — Thu, 15 Oct 2009 13:44:51 GMT

You can use a tMap: create 2 output and filter the output on the first column, redirect your two outputs on two new csv files. This should do the trick.

Re: Split File group by...

Anonymous — Thu, 15 Oct 2009 14:39:19 GMT

Thank You, i know how to do that.
I didn't explained enough : i don't know in my source file if i got just A and B, or A, or ABCDEF...
So i don't know how much files will be outputed...

Re: Split File group by...

Anonymous — Fri, 16 Oct 2009 07:14:52 GMT

Just for my information, do you see my email adress as author of this post ?

Re: Split File group by...

Anonymous — Fri, 30 Sep 2011 20:18:10 GMT

I have the same thing want to do? Do you find a solution?