Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

tMap output to tWarn

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.
Labels (2)
10 Replies
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

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

Are you using TOS-DI ?
--
Regards,
Vinod
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

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,
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

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