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

Catch processed row's count

Hi there,

 

I'm using TDI open studio. I have designed and run the job, whose screenshot is :

 

0683p000009LwMQ.png

 

As you can see, there we are getting count of processed rows in green colour. I want to catch these count in separate file (prefer excel file).

 

So for above job, I expect below output :

0683p000009LwTp.png

 

 

After researching for a while, I come to know that there are 3 components that I feel one of these 3 can fulfill the requirement.

tStatCatcher

tLogCatcher

tFlowMeterCatcher

 

But I don't know which one to use and how to use it for my requirement. Please, help me out guys. 

 

Thank you 0683p000009MACn.png

 

Labels (2)
12 Replies
Anonymous
Not applicable
Author

Thanks @xdshi

 

I've tried tStatCatcher, and got the duration as well. But then I've to apply some lookup logic using tMap to get result of both in one output table containg row count (from tFlowMeterCatcher) and duration(using tStatCatcher).

 

I was basically looking for a way to add one more column for TIME  in result of tFlowMeterCatcher. This column must contain values as duration of the specified component.

Anonymous
Not applicable
Author

Hello,

So far, you cannot edit the schema setting of tFlowMeterCatcher component.

 

0683p000009LwZJ.png

Best regards

Sabrina

 

 

hangel
Contributor
Contributor

Hello xdshi,

Good Day

I want to achieve similar outcome from talend.

I'm extracting data from Salesforce component and injecting the data in to influxdb and building dashboard in Grafana. I have a use case to get the count of status wrt location.

Eg:
Location New Pending Approved Total
CA 1 3 5 9
HE 4 6 8 18

Let me know which component to use in talend to achieve this case.