topic Adding Timestamp to Error log Rows (tFileOutput_delimited) in Talend Studio

Adding Timestamp to Error log Rows (tFileOutput_delimited)

Moro — Fri, 15 Nov 2024 22:26:27 GMT

Hi All 🙂

I would really appreciate your help with this topic.

I am collecting all the rejects in a error log file using component tFileOutput_delimited. Next to every error log row I would like to have the current time stamp since the error log will be filled again with further errors when the job is run next time.

I tried to add a column in the schema type date but I couldnt make this work.

Would anyone of you have any suggestions on how to start with this topic?

Thank you very much!!

Re: Adding Timestamp to Error log Rows (tFileOutput_delimited)

Anonymous — Thu, 20 Oct 2022 09:06:29 GMT

Hello,

You can add a tMap component before tFileOuputDelimited component, add setup expression to "new Date()" to the new added date field, and setup the Date Pattern to "yyyy-MM-dd HH:MM:SS" for the field as the below

Re: Adding Timestamp to Error log Rows (tFileOutput_delimited)

Moro — Thu, 20 Oct 2022 09:13:23 GMT

thank you so much 🙂

I just tried it and dont know why it isnt working ( I am not getting an error message though)

Re: Adding Timestamp to Error log Rows (tFileOutput_delimited)

Anonymous — Thu, 20 Oct 2022 09:54:59 GMT

Hello,

Regarding to your snapshot of the job, it should already write the current date value to the 'date1' field in the output file of tFileOutputDelimited_8 component, could you please double check it? is this what you expected?

Re: Adding Timestamp to Error log Rows (tFileOutput_delimited)

Moro — Thu, 20 Oct 2022 13:05:00 GMT

True, I didnt add the date row in the tFileOutputDelimited component.

Thank you very much! Very appreciated!

Re: Adding Timestamp to Error log Rows (tFileOutput_delimited)

Moro — Thu, 20 Oct 2022 14:04:27 GMT

Is it possible to also add a location like the name of the excelsheet and its sheet and position? Also using tmap? Is there also a setup expression? Where can I find a list of those existing expressions?

Thank you!

Re: Adding Timestamp to Error log Rows (tFileOutput_delimited)

Anonymous — Fri, 21 Oct 2022 06:34:10 GMT

Hello,

it need to fetch the name of the excelsheet first.

when you click the button "..." on the expression, it will popup a dialog which will list all the existing expressions & functions