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
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,
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
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
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?