topic Count of rejected rows in tFileinputdelimited component in Talend Studio

Count of rejected rows in tFileinputdelimited component

Anonymous — Mon, 06 Jan 2014 06:44:44 GMT

hi
I want to capture the number of rejected rows from tfileinputdelimited component my workflow is as follows
tfilelist----->tfileinputdelimited----->tlogrow
|
|
tfileoutputdelimited(reject row) file is in appending mode

Now if two files are listed ,the rejected rows from 2 file will be written to tfileoutputdelimited in appending mode , i want to find out rejected rows for individual listed files. How to get the rejected values.

Does value for ((Integer)globalMap.get("tFileOutputDelimited_2_NB_LINE")) won't propagate on on component ok link

Re: Count of rejected rows in tFileinputdelimited component

Anonymous — Mon, 06 Jan 2014 06:57:03 GMT

Hi,
What the expected rejected values looks like(see my pic)? Could you elaborate your case with an example with input and expected output values.
Best regards
Sabrina

Re: Count of rejected rows in tFileinputdelimited component

_AnonymousUser — Tue, 14 Oct 2014 18:57:42 GMT

Hi
I want to catch reject record by tFileinputdelimited into tfileoutputdelimited,
but i want rejected record as it is originally present in input file.
generally i am getting rejected record with adding/removing extra delimiter.
can anyone help on this

Re: Count of rejected rows in tFileinputdelimited component

Anonymous — Tue, 14 Oct 2014 19:42:37 GMT

You can send the reject flow to a tMap and build an output flow for the rejected records with the same schema like the original input component. To do that connect the reject flow to a tMap. Add to your job and tFileOutputDelimited (for the rejected records) and the as schema the schema of the tFileInputDelimited (origin of your data) by copy and paste the columns in the schema editors.
Now connect the tMap with the new tFileOutputDelimited and accept the target schema for this flow.
Within the tMap you can adapt the reject flow schema to the new output.

Re: Count of rejected rows in tFileinputdelimited component

_AnonymousUser — Tue, 14 Oct 2014 20:21:02 GMT

yes i did same but if we have extra delimiter in between record so reject is automatically deleting number of extra delimiter from end of record.

Re: Count of rejected rows in tFileinputdelimited component

Anonymous — Wed, 15 Oct 2014 04:21:03 GMT

Hi rktalend1,
Could you elaborate your case with an example with input and expected output values? Screenshots will be preferred.
Best regards
Sabrina

Re: Count of rejected rows in tFileinputdelimited component

_AnonymousUser — Wed, 15 Oct 2014 07:35:20 GMT

hi xdshi,
don't know why talendforge not working that's why unable to login to forum so unable to post screen shot.
my log something like tfileinputdelimited---->tmap------>tmssqloutput
|
|rejectflow
tfileoutputdelimited.
file
1|xyz|123|assada4646|india|29
2|xyz|123|ass|ada|4646|india|29
3|xyz|123|assada4646|india|29
4|xyz|123|assada4646|india|29

in by reject flow second record will reject
it will be in tfileoutputdelimited something like that
2|xyz|123|ass|ada|4646
because it match schema with tfileinputdelimited in this case in reject floe we are loosing valie of last 2 column.
i want reject record as it is in original file..

Re: Count of rejected rows in tFileinputdelimited component

Anonymous — Wed, 15 Oct 2014 08:55:51 GMT

Whats wrong with my suggestion you set a tMap in the reject flow and build in this way your reject output flow as you need?

Re: Count of rejected rows in tFileinputdelimited component

_AnonymousUser — Wed, 15 Oct 2014 09:26:02 GMT

thanks jlolling but i am not getting desired o/p record as i mentioned i want rejected record as it it which originally present in source file.

Re: Count of rejected rows in tFileinputdelimited component

Anonymous — Wed, 15 Oct 2014 09:41:06 GMT

OK, in this case you have to read the lines of the input file not with a tFileInputDelimited instead use the component tFileInputRow and read the whole line at once. After reading it into one schema column you need to separate the fields with tExtractDelimitedFields and of there is something wrong you can use the original input line for the reject flow.

Re: Count of rejected rows in tFileinputdelimited component

Anonymous — Mon, 05 Jan 2015 22:10:13 GMT

Hi, I need to counts the records that are loaded successfully and rejected records as well and also those failed records should be back to file landing zone.

Re: Count of rejected rows in tFileinputdelimited component

Anonymous — Tue, 06 Jan 2015 06:11:21 GMT

Why not, every input and output component has similar counters.