topic How to insert to table has an auto increment field with tDBOutput? in Talend Studio

How to insert to table has an auto increment field with tDBOutput?

Anonymous — Tue, 22 Aug 2017 11:28:04 GMT

Hi all,

I have thousand CSV data rows and I want to insert them into a table has an auto increment field, I use:

tFileDelimited -> tMap -> tDBOutput But it insert data with wrong columns order

I print SQL query to console by tJava with ((String)globalMap.get("tPostgresqlOutput_5_QUERY")), then copy the query to Database IDE and excute, it work - insert successful.

What happend with my job ? And How to insert to table has an auto increment field with tDBOutput?

Thank all.

Re: How to insert to table has an auto increment field with tDBOutput?

Anonymous — Tue, 22 Aug 2017 13:24:12 GMT

Hi,

For auto-increment, you can use a sequence with Numeric.sequence("s1",1,1), you can find it on tmap java editor in category Numeric. But this sequence is only good for an unique use... if your job is re-run , the sequence back to 1 (but you can initialize with the max Numeric.sequence("s1", globalMap.get("MaxRow") ,1) ) or someting like that...

I don't know if this help you .

Good luck

SGV

Re: How to insert to table has an auto increment field with tDBOutput?

Anonymous — Wed, 23 Aug 2017 04:20:25 GMT

Thank you, it work