How to request Max(Primary Key) from Db and assign to variable in TOS

[Anonymous]

Hi All,

How can we request Max(PK) from DB and assign to a variable and use this variable in tmap numeric.seq.

If someone can explain this with screenshot on how job to be designed it would be great.

Input table DB-Oracle

Output Table DB-Mysql

[vapukov]

HI @pabburi 

you just need to search! 🙂 all already here!

and you will have a lot of answers to your question:

https://community.talend.com/t5/Design-and-Development/store-the-dynamic-values-in-context-variable/...

https://community.talend.com/t5/Design-and-Development/resolved-SELECT-query-from-tPostgresqlInput-a...

https://community.talend.com/t5/Design-and-Development/how-to-save-a-value-from-table-to-context-var...

but, this is not all! 🙂

Talend Team make great work for us - they share demo projects with each Studio! all what we need it just import it:

and go thru all examples:

DEMO project is really Must See before any other future questions, it an excellent resource for studying

another old, but useful resource - https://www.talendbyexample.com/

Take a look! and community members will be happy to help you with many troubles and problem during your tests!

with best regards, Vlad