topic Re: Data_integration in Talend Studio

Data_integration

FarCry — Wed, 11 Apr 2018 03:16:49 GMT

i'm trying to load xlsx file into postgresql database. my excel file contiens 11262 row but after excuting the job i find 14**** row and i don't know why i want only to find my 11262 row in my table

Re: Data_integration

Anonymous — Wed, 11 Apr 2018 09:03:01 GMT

Hello,

Have you tried to use "Rejects" row from your tpostgresqlOutput component to see if there exists rejected rows?

Please uncheck "Use Batch Size" option in Advanced Settings of your tpostgresqlOutput component.

Best regards

Sabrina

Re: Data_integration

Anonymous — Thu, 12 Apr 2018 00:58:05 GMT

check your excel file there is probably approx 2,000 rows that have a space or similar in one of the columns hence the additional rows in the talend job. I'd just select 3,000 rows after the last populated row and delete them in the spreadsheet

Re: Data_integration

manodwhb — Fri, 20 Jul 2018 05:48:54 GMT

@fat_ma,try to execute with Traces Debug and see what is happening ?

Re: Data_integration

manodwhb — Thu, 02 Aug 2018 11:04:49 GMT

@fat_ma,still do you have issue?

Re: Data_integration

FarCry — Thu, 02 Aug 2018 17:48:06 GMT

##- No i have found the solution -##
ᐧ

Re: Data_integration

Anonymous — Wed, 21 Nov 2018 18:19:32 GMT

@fat_ma - Could you please share the solution you had discovered so that it will benefit the Talend community members in future? When you are providing the solution, please also mark it as the one which has got the solution for this post.

This will help in enriching our Talend community.

Warm Regards,

Nikhil Thampi