topic Re: Split a file in Talend Studio

Split a file

Anonymous — Tue, 18 Dec 2018 16:32:47 GMT

Hi!

I have a delimited flat file of 1000 lines, I want to divide it into 3 files, depending on the value of column 0, how do I do this? If the value of column 0 is == 1, go to a file; if the value is == 2 it goes to another file.

Thanks!

Re: Split a file

TRF — Tue, 18 Dec 2018 16:58:09 GMT

First solution, 1 tMap with 3 output flow and the appropriate filter expression for each.

Second solution, 1 tFilterRow to separate records for file 1, then a second one to separate records for file 2 and 3.

Re: Split a file

Anonymous — Tue, 18 Dec 2018 17:06:41 GMT

something I forgot to mention is that those that are type 1 and type 3 have fewer fields than type 2, does this affect?

Re: Split a file

Anonymous — Tue, 18 Dec 2018 17:30:13 GMT

when I execute it, a Null Pointer error is generated

Re: Split a file

Anonymous — Tue, 18 Dec 2018 17:39:52 GMT

Hi,

It seems your Column0 is having null values. Could you please modify the code as below to handle the null scenario?

Relational.ISNULL(row1.Column0)? null : ((row1.Column0==1) ? row1.Column0 : null)

Warm Regards,
Nikhil Thampi

Please appreciate our members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: Split a file

Anonymous — Tue, 18 Dec 2018 17:55:06 GMT

I already managed to write different files, but now I want those who do not fulfill the condition, NOT to occupy unnecessary lines.
Thanks!

Re: Split a file

Anonymous — Tue, 18 Dec 2018 18:04:00 GMT

Hi,

The tmap says that your Column0 is not nullable. I hope you have checked the input data is not having any null value for Column0. Also I hope you are not picking any null rows.

If you have checked both these conditions, then you will have to check the functions. Somewhere you are passing the value as null.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: Split a file

Anonymous — Tue, 18 Dec 2018 18:06:39 GMT

I already managed to write different files, but now I want those who do not fulfill the condition, NOT to occupy unnecessary lines.
Thanks!

Re: Split a file

Anonymous — Tue, 18 Dec 2018 18:11:20 GMT

Hi,

Either you can add an null check expression in your output area so that it will not write the empty data. Or you can avoid them by filtering later using a tfilterrow component.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: Split a file

Anonymous — Tue, 18 Dec 2018 18:11:59 GMT

I already managed to write different files, but now I want those who do not fulfill the condition, NOT to occupy unnecessary lines.
Thanks!

Re: Split a file

Anonymous — Tue, 18 Dec 2018 18:15:25 GMT

Hi,

Are you saying that you are still facing the issue? I hope my previous post solves your query.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: Split a file

Anonymous — Tue, 18 Dec 2018 21:03:27 GMT

Thanks!

This is the solution to my problem