topic Re: tLoop on a tFileInputDelimited : loop number of rows in Talend Studio

tLoop on a tFileInputDelimited : loop number of rows

Anonymous — Wed, 29 Feb 2012 14:35:25 GMT

Hello
I put a tLoop on a tFileInputDelimited component in order to loop on it. For the tLoop component, there is a "to" param to define (default value : 10). If I have a non deterministic number of row in the tFileInputDelimited, how can I define the "to" param of tLoop in order to loop at least the number of the row that we have in the file?
thks
Valery

Re: tLoop on a tFileInputDelimited : loop number of rows

Anonymous — Wed, 29 Feb 2012 14:37:37 GMT

Hi,
Use tFileProperties to find the number of rows in your file.
Good luck

Re: tLoop on a tFileInputDelimited : loop number of rows

Anonymous — Wed, 29 Feb 2012 14:40:19 GMT

Hi,
Not sure what you are trying to do here. The file gets read row by row for all rows in it, you don't need a loop there. Can you explain the need for the loop?
Regards,
Arno

Re: tLoop on a tFileInputDelimited : loop number of rows

Anonymous — Wed, 29 Feb 2012 15:21:26 GMT

Correct Arno, I did not understand why at the begin. Effetively tFileInputDelimited read row by row.
but in https://community.talend.com/t5/Design-and-Development/how-to-add-an-empty-row/td-p/114679 they are using it. I don't really understand why but it runs.
Valery

Re: tLoop on a tFileInputDelimited : loop number of rows

Anonymous — Wed, 29 Feb 2012 15:28:42 GMT

Okay, in case you want to add rows like in that case I get it.
Using tFileProperties, like saukema suggested, is the correct solution i suppose.
Regards,
Arno

Re: tLoop on a tFileInputDelimited : loop number of rows

Anonymous — Wed, 29 Feb 2012 15:31:38 GMT

Arno,
If you get it, could you explain it me brievely?
thks
Valery

Re: tLoop on a tFileInputDelimited : loop number of rows

Anonymous — Wed, 29 Feb 2012 15:35:49 GMT

unfortunately ((Integer)globalMap.get("tFileInputDelimited_1_NB_LINE")) is null when I am launching the job. Any idea?
Valery

Re: tLoop on a tFileInputDelimited : loop number of rows

Anonymous — Thu, 01 Mar 2012 07:01:33 GMT

Hi Valery,
Still unsure about what you are trying to achieve here. Do you just want to replicate what's done in the other thread, or do you have a need to insert empty rows?
Regards,
Arno

Re: tLoop on a tFileInputDelimited : loop number of rows

Anonymous — Thu, 01 Mar 2012 09:01:08 GMT

Hello
Insert an empty row
Valery