tlogrow not showing all records

[RAJ6]

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.

[Anonymous]

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

[RAJ6]

 standard and advanced tabs screenshots.

[Anonymous]

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());

[cterenzi]

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.

[RAJ6]

Hi @cterenzi

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

[Anonymous]

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

[javvaji]

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.