topic Re: count no. of rows from multiple tables in Talend Studio

count no. of rows from multiple tables

Anonymous — Fri, 11 May 2018 10:53:55 GMT

hello,

i want to count of no. of rows from multiple tables and create one output table and load data with curent datetime column and another one column of "total time of job running". ? which component or which expression i used? help

Re: count no. of rows from multiple tables

Anonymous — Fri, 11 May 2018 11:52:16 GMT

Look at the components you are using by making use of Talend's component guides (https://help.talend.com/search/all?query=Talend+Components+Reference+Guide). For each component there is a Global Variables section which describes variables that Talend assigns values to informing you of certain component metrics. You can see these in the "Outline" window in the bottom left of the Studio. Expand the tree for your component and you can see the Global Variables available and also drag them to a tJava (or other components) so that you can make use of them. They are stored in a Java HashMap called "globalMap.

Re: count no. of rows from multiple tables

Anonymous — Fri, 11 May 2018 13:44:04 GMT

sir, i have multiple jobs and want row count no. on different columns like "TotalEmail"from job1 ,"EmailRejected" from job2 , "TotalphNo."from job1 ,"RejectedPhoneNo." from job 2 and apply rowCount and load it to mysqldb table what can i do?
actully i m new on talend so i am confused.

Re: count no. of rows from multiple tables

Anonymous — Fri, 11 May 2018 14:13:36 GMT

This tutorial shows it in more detail https://www.talendbyexample.com/talend-studio-outline-panel-reference.html

I'm afraid the best way to learn Talend (anything) is to try it out. Have a play and see what you can figure out based on what I have told you and the links I've supplied.