topic Re: tlogrow not showing all records in Talend Studio

tlogrow not showing all records

RAJ6 — Sat, 16 Nov 2024 09:25:22 GMT

Hi Talend folks,

In my excel have 665 rows are there. I imported that excel file for metadata. Then used tFileInputExcel connected to tlogrow. When I ran it shows only 608 rows.

Re: tlogrow not showing all records

Anonymous — Thu, 10 Aug 2017 12:42:57 GMT

Can you show us your Excel component's configuration please? Bot the standard and advanced tabs

Re: tlogrow not showing all records

RAJ6 — Thu, 10 Aug 2017 13:16:42 GMT

standard and advanced tabs screenshots.

Re: tlogrow not showing all records

Anonymous — Thu, 10 Aug 2017 13:34:46 GMT

Nothing seems out of the ordinary there. Have you checked the content that is being printed by your tLogRow? Do you notice any missing rows? Sometimes (although not often these days) the row stats can be out (on the workspace...when viewed using the AMC stats they are correct). Can you check this and see what is actually being printed to your output? You can check the the number of rows output by connecting a tJava to your tFileInputExcel with a OnSubJobOk link. The use the code below to print the number of rows to your output...

System.out.println("Rows = "+((Integer)globalMap.get("tFileInputExcel_1_NB_LINE")).intValue());

Re: tlogrow not showing all records

cterenzi — Thu, 10 Aug 2017 16:02:55 GMT

Is it possible rows are being rejected by the input component? Connect the Reject flow from the input file to a log or file component to see if some rows don't conform to the schema.

Re: tlogrow not showing all records

RAJ6 — Fri, 11 Aug 2017 06:39:44 GMT

Hi @cterenzi

Yes you are correct. some rows don't conform to the schema in my excel. How to find and solve the problem?

Re: tlogrow not showing all records

Anonymous — Mon, 14 Aug 2017 08:23:30 GMT

Hi,

What does your rejected rows look like when you connect the Reject flow from the input file to a log or file component? Did you set any length or precision in your schema setting?

Best regards

Sabrina

Re: tlogrow not showing all records

javvaji — Thu, 17 Aug 2017 14:45:56 GMT

Hi,

Please check the NB_Line function of a component to print number of lines processed.

And also check the output rows and compare with the source to identify which records are missing.

Thanks,

Bharath.