topic Re: Unable to check if table exists in Talend Studio

Unable to check if table exists

Anonymous — Sat, 16 Nov 2024 12:21:17 GMT

Hello,
I am new to Talend and I would like to create a job that checks if a table exists in Postgres, and if it does retrieve a certain max() value and place it in a variable X, if it doesn`t set the X variable to 0.
Could someone please help me out?
Thank you,
Andras

Re: Unable to check if table exists

Anonymous — Wed, 22 Feb 2012 02:58:01 GMT

Hi Andras
Welcome to Talend Community!
According to your requirement, you can create job as follows. If this is the first time using TOS, maybe it's a little complex.
tPostgreSQLInput-->main-->tJavaRow
|
OnSubjobError
|
tJava

Regards,
Pedro

Re: Unable to check if table exists

Anonymous — Wed, 22 Feb 2012 09:28:09 GMT

Thank you for your answer.
Instead of using tJava can I do this If/Else in tMap? I know that tMap does not support If/Else, but is there a way of coding the tMap to do a check like:
if(row1.X==null){
row1.X = 1;
} else{
row1.X++;
}

Re: Unable to check if table exists

Anonymous — Wed, 22 Feb 2012 09:29:30 GMT

Hi
Try this expression.

row1.X==null?1;row1.X++

Regards,
Pedro

Re: Unable to check if table exists

Anonymous — Wed, 22 Feb 2012 16:11:06 GMT

It works perfectly!
Thanks a lot!

Re: Unable to check if table exists

Anonymous — Wed, 22 Feb 2012 21:05:50 GMT

Actually ++ doesn`t work for increment in Talend, I had to use Variable+=1 in stead of Variable++.

Re: Unable to check if table exists

Anonymous — Thu, 06 Jun 2013 13:40:10 GMT

I guess it works, it's just the post increment effect, use ++X (pre increment)