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: 
spr654
Creator
Creator

Setting a log for the job in Open Studio 7.1: NB_LINE is null, but job returns rows

Hi,

 

I am trying to setup a log file to catch things like number of total rows, number of rows that go to this component, or that component...I have created, with that purpose, a tWarn  that I link to a specific part of my job to get results, then I have a tlogcatcher. Sometimes, it works, but sometimes, it doesn't. I will provide an example.

 

Here is the execution of my job:

 

0683p000009M3O9.png

 

Here is the content of the tWarn:

"number of lines: "+((Integer)globalMap.get("tFileInputDelimited_4_NB_LINE"))+" Customer address number of records: "+ ((Integer)globalMap.get("tExtractJSONFields_4_NB_LINE"))

 

Here is what I expected:

number of lines: 26424 Customer address number of records: : 15424

 

Here is what I get:

number of lines: 26424 Customer address number of records: : null

 

As well, how can I capture the 2 branches of the tMap (12152 and 14272 lines respectively).

 

Any help is welcome.

Labels (3)
1 Solution

Accepted Solutions
fdenis
Master
Master

on ouline tab (under Repository) you can access public globalMap datas.
f1 when you have selected the component.
if you are fluent in java, you can go to code tab.

pleas tag as solved when it's done.
Regards,

View solution in original post

6 Replies
fdenis
Master
Master

tExtractJSON is not finshed when warn is activated….
spr654
Creator
Creator
Author

Hi,

 

I have a trigger when subjob ok linking the tWarn with the subjob. Theoretically, tWarn won't be active until the subjob ends.

fdenis
Master
Master

I'm agree but I did not see tExtractJSONFields_4 into your subjob
spr654
Creator
Creator
Author

Thanks for your answer.

Is it the same for tMap outputs? Where can I find documentation on this topic?

Thanks again
fdenis
Master
Master

on ouline tab (under Repository) you can access public globalMap datas.
f1 when you have selected the component.
if you are fluent in java, you can go to code tab.

pleas tag as solved when it's done.
Regards,
spr654
Creator
Creator
Author

Thanks,

 

Now I know what can and what cannot be done.