[resolved] how to catch rejects tmap

[Anonymous]

Hello,
I searched the forum and I have read a lot of postings but I don´t understand how to catch the rejects
when using tmap.
I use two database connectons (tAS400Input) and tMap to create a new csv file (tOutputDelimited).
In the Start (Job....) I see :
Run Job ..... at
connecting to socket on port
connected
For input string: "....." <- this line comes each time a semicolon was used in a field where it should not be used
How can I write this lines in a csv file or tLogRow
I have seen that it´s possible to make "links" with rejects instead of Main or Lookup
hope someone can help me.
Greetings

[Anonymous]

Hi
Can you upload some screenshots of job? You should find out the error is thrown on which component
Best regards
Shong

[Anonymous]

I double checked and have to give you more details about my job.
I´m exporting data from our AS400 system, the data are written in a csv file.
Then I use these csv files as Inputfiles (tFileInputDelimited) and there I get the error
because there are semicolons in a field because a users used them to seperate text.
Now the programm understands the semicolon as seperator for fields.
For example:
if I have a table with 5 column (name,address,description,phone)
and someone write a semicolon in the the description it will end up in
5 column because semicolon is used to seperate fields and the field phone will be filled with
a part of the description.
At the attached screenshot you can see the Output that I want in an Errorlogfile.
Can I get an error log with tMap and tLogRow?
Who and where do I use tLogRow to get the wrong rows?

[Anonymous · Accepted solution]

Hi
The error occurs on tFileInputDelimited component, not tMap! You can get the reject rows from tFileInputDelimited by unchecking the box 'die on error', for example:
tFileInputDelimited--main---other components
--reject--tLogRow
If you check the box 'die on error' on tFileInputDelimited, the job will throw the exception and stop once it meets an error.
Best regards
Shong

[Anonymous]

Thank you very much.
Bevore I tried 100 times but I didn´t get the reject entry but now I see it.

[Anonymous]

Thank you very much.
Bevore I tried 100 times but I didn´t get the reject entry but now I see it.

Cool, thanks for your feedback!
Best regards
Shong