topic Re: [resolved] Stop reading rows from Input (csv or excel) when field "end" = "x" in Talend Studio

[resolved] Stop reading rows from Input (csv or excel) when field "end" = "x"

Anonymous — Sat, 16 Nov 2024 13:08:27 GMT

How can I stop reading rows from a input file (csv or excel) when a field has a certain value?
So if in field "end" the value is "x" I would like stop/interupt reading new rows from the input.
The Job should not end with a error.
Thank you for your help 🙂

Re: [resolved] Stop reading rows from Input (csv or excel) when field "end" = "x"

Anonymous — Tue, 18 Jan 2011 06:39:36 GMT

Hello
It is impossible to stop reading the new row from the input component, but we can stop it when a fileds end with 'x' on tJavaRow component, so need to read all the rows from file and filter/process on tJavaRow.
Best regards
Shong

Re: [resolved] Stop reading rows from Input (csv or excel) when field "end" = "x"

Anonymous — Wed, 19 Jan 2011 21:51:29 GMT

Hello Shong,
so how would I Skip all following lines when I see the first apereance of the string "x" in row1?
Would I have to use a variable to do this?
Greetings
Roger

Re: [resolved] Stop reading rows from Input (csv or excel) when field "end" = "x"

Anonymous — Thu, 20 Jan 2011 08:34:13 GMT

Hello
Here is simple demo job, the tFileInputFullRow extract all the records from the source file:
source file:
a
b
c
x
c
d
result:
Starting job forum13857 at 16:35 20/01/2011.
connecting to socket on port 3783
connected
a
b
c
x
disconnected
Job forum13857 ended at 16:35 20/01/2011.

Best regards
Shong

Re: [resolved] Stop reading rows from Input (csv or excel) when field "end" = "x"

Anonymous — Thu, 20 Jan 2011 12:11:55 GMT

Hello Shong,
This is exacly what I was looking for.
Many thanks for this quick response.
Greetings
Roger

Re: [resolved] Stop reading rows from Input (csv or excel) when field "end" = "x"

Anonymous — Thu, 09 Feb 2012 10:18:48 GMT

Will the tFileInputFullRow read all the lines in the file in here??? if that is the case then it will consume time in reading the file right, which is not an efficient way