Hello,

I am at my first contact with Talend and under pressure too, please give me a hand.

I need to read a value (SEQFIC) from an one-row input delimited file downloaded from FTP (done this) and compare the value from a field retrieved from a MySQL table (MRRD_Sequence_File).

If the MySQL table has no rows, or SEQFIC == MRRD_Sequence_File + 1, then continue the job; else die.

I thought to do the comparison in a tMap, but I do not know how to build comparison expressions, how do I test the number of rows in the table, and how do I test  SEQFIC_A == MRRD_Sequence_File + 1?

I attach the screenshot showing what I tried until now, but that doesn't work and I'm stuck.

Please give me a hint how to do this, I can not find something similar nor in the Talend documentation, neither among the tutorials on the Talend site.


Thank you very much.

Last edited by Furnica (2009-08-17 16:29:55)