topic Re: tMap output to tWarn in Talend Studio

tMap output to tWarn

Anonymous — Tue, 14 Aug 2012 09:03:35 GMT

Hi all,
I would like to retrieve an tMap output (hundred columns) and send it directly to a tWarn for logs.
Would you have a suggestion ?
Thanks in advance.

Re: tMap output to tWarn

Anonymous — Tue, 14 Aug 2012 09:22:43 GMT

shousseine,
What kind of logging do you mean? It seems you want to get the data from the tMap output shown?
If so use a tLogrow next to your tMap.
Regards

Re: tMap output to tWarn

Anonymous — Tue, 14 Aug 2012 09:37:02 GMT

Thanks mpa,
My tMap output are my logs I retrive with my tlogCatcger. Here are screenshots for illustration

Re: tMap output to tWarn

Anonymous — Tue, 14 Aug 2012 09:52:06 GMT

Are you using TOS-DI ?
--
Regards,
Vinod

Re: tMap output to tWarn

Anonymous — Tue, 14 Aug 2012 09:56:10 GMT

shousseine,
What exactly do you want to do with the output of tMap_1?
Do you want this output in a file? In the console?
Regards

Re: tMap output to tWarn

Anonymous — Tue, 14 Aug 2012 10:12:57 GMT

Thanks both.
@ vinod_talend Yes I'm using TOS DI 5.1.1
@mpa I would like to send my tMpa_1 output to my tWarn in order to use it as "message" for my tLogCatcher.
Thks

Re: tMap output to tWarn

Anonymous — Tue, 14 Aug 2012 10:31:50 GMT

shousseine,
So in your logging file you want the columns from tStatcatcher "merged" with the extra 100 columns from your xml files?
Or do you want to have those 100 columns in the message column or..?
What does your xml file contain? 1 row.. 1000 rows?
Regards

Re: tMap output to tWarn

Anonymous — Tue, 14 Aug 2012 10:56:26 GMT

thank you mpa,
I'll give more details about my problem.
I have 2 xml file as input I want to compare the lines one by one to see if there's conflicting data
xml1----------main----tmap------process.
xml2---------lookup--'
In my tmap I have treatements like this
-----row1.REFERENTIAL_SOURCE.equals(row2.REFERENTIAL_SOURCE)?"":"VALUE different for REFERENTIAL_SOURCE (ID,Ref,CFO)"+"|"+row1.BUSINESS_ID+"|"+row1.REFERENTIAL_SOURCE+"|"+row2.REFERENTIAL_SOURCE
(for my hundreds columns in my xml files)
I would like to have this : ("" Or "VALUE different for My_Column ........" ) in my log file.
This log file is processed like this (see screenshot). "Message" is retrieved from my tWarn
My question is how to have my output from tMap_1 in my tWarn (so I use it in my tLogCatcher------tMap-----tfileOutputdelimited who is my log file)
The xml file contains about 200 records
regards,

Re: tMap output to tWarn

Anonymous — Tue, 14 Aug 2012 11:15:35 GMT

Hi shousseine,
Your Job looks perfetly fine to me, and it will capture pretty much what it is supposed to be, but it appears as you are trying to capture the errors also which might occur due to unavailability of the file or other runtime errors, unfortunately that much extensive logging is not there, for example level of log4j logging. However for the same purpose you can redirect the logs from following location, select File > Edit Project Properties then click Stats & Logs, then click on Use logs(tLogCatcher) then provide file credentials or the databse credentials to log the error also make sure following are checked Catch runtime errors, Catch user errors, Catch user warnings
Hope that helps.
--
Regards,
Vinod

Re: tMap output to tWarn

Anonymous — Tue, 14 Aug 2012 12:12:05 GMT

Thanks vinod_talend
effectively I also capture errors and other warnings but that is OK.
But I'm stuck on this : tMap-----main----->tWarn. Sending data to my tWarn from my tMap.
Any suggestions
regards

Re: tMap output to tWarn

alevy — Thu, 16 Aug 2012 01:58:57 GMT

You can set the "Warn message" in tWarn to use the column values from the tMap output e.g. "Field A value = "+out1.fieldA. That then becomes the message column value from tLogCatcher.
Still not clear exactly what problem you're having. Are you trying to concatenate all the column values from tMap into the message?