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

One Star

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

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 :-)

Accepted Solutions
Community Manager

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

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
----------------------------------------------------------
Talend | Data Agility for Modern Business

All Replies
Community Manager

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

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
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

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

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
Community Manager

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

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
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

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

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

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

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