topic Re: If table is empty then do nothing else do in Talend Studio

If table is empty then do nothing else do

Anonymous — Sat, 16 Nov 2024 12:40:39 GMT

At the moment I try to optimize a bidirectional connection between an interface database and a Sage database.
I nearly solved the whole problem. I still have one big problem.
The data goes from one mysql table to one or more mssql tables. If there is no content in the mysql databas the job
should not run. If there is content the job should run.
At the moment the job runs under an inifinite loop. This is no good solution.
Where and how to place the statement?

Re: If table is empty then do nothing else do

Anonymous — Tue, 20 Sep 2011 02:55:54 GMT

Hi
To determine a table is empty or not, only select one row from the table, for example:
tMysqlInput_1--main--tJavaRow
|
tJava---runIf---next processing
on tMysqlInput_1, write the query as below:
"select * from tableName limit 1"
There is a global variable ((Integer)globalMap.get("tMysqlInput_1_NB_LINE")) counts the total number of rows are queried.
on tJava:
if(((Integer)globalMap.get("tMysqlInput_1_NB_LINE"))>0){
globalMap.put("isContinue",true);
}else{
globalMap.put("isContinue", false);
}
set the condition of runIf as:
(Boolean)globalMap.get("isContinue")
The next processing will fires if the table has at least one row.
Best regards
Shong

Re: If table is empty then do nothing else do

Anonymous — Wed, 21 Sep 2011 16:10:30 GMT

Thank you, for your help! But how to integrate the solution in my case?

Re: If table is empty then do nothing else do

Anonymous — Wed, 21 Sep 2011 18:35:56 GMT

Hi
I think u need to try tWaitForSqlData

Re: If table is empty then do nothing else do

Anonymous — Thu, 22 Sep 2011 11:46:03 GMT

Great idea, but where to place in my job?

Re: If table is empty then do nothing else do

Anonymous — Fri, 23 Sep 2011 15:11:45 GMT

Hi ,
You can use this instead of infiniteLoop, as the loop will only start when there is data in the table or data is inserted.