Talend community forum / USage of Variable NB_LINE (Number of line)

cenbells · 2007-10-11 14:38:34

Hi Folks,

i just came across the variable NB_LINE of a tFileInputCSV component. Its description says that it contains the number of the line.
Either the description is misleading or there is a problem with the variable. Currently (2.2.0GA) it is only available after the Job reading a csv is finished. Hence it contains the total number of lines in the input file.

But especially for logging it would be helpful to get the actual line of the file. I helped myself by looking it up in the code and directly accessing the variable nb_line_tFileInputCSV_x for this task.

I just wondered if this is as intended or if it is a problem with the variable?

Kind regards,
Ken

shong · 2007-10-12 08:52:37

Hi Ken

In fact, The variable NB_LINE is the number of processing rows.

I just wondered if this is as intended or if it is a problem with the variable?

Via NB_LINE, we can know that how many records have been processed successfully.

Best regards

shong

benjams007 · 2007-11-19 05:01:48

I used this variable just fine. I like to keep the file position (IE location of the line being parsed) in the DB so that I can always find it later if need be. I used the following line to put this into the output file

output_row.file_position= nb_line_tFileInputCSV_1;

Happy logging

Announcement

Unanswered posts

#1 2007-10-11 14:38:34

USage of Variable NB_LINE (Number of line)

#2 2007-10-12 08:52:37

Re: USage of Variable NB_LINE (Number of line)

#3 2007-11-19 05:01:48

Re: USage of Variable NB_LINE (Number of line)

Board footer