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
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
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++; }
