Error in tFileRowCount.

One Star

Error in tFileRowCount.

Hi,
i am using tFileList_1------(iterate)------>tFileRowCount.
in tFileList1,i want to read .xlsx file and by iterating it i want to count no of records present in perticulat .xlsx file which i want to do with tFileRowCount and i am providing filename in tFileRowCount as, ((String)globalMap.get("tFileList_1_CURRENT_FILEPATH")), but it showing error as "java.lang.RuntimeException: not support excel 2007".
so how to remove that error.
so will u please suggest me how to remove that error.
Thanks
One Star

Re: Error in tFileRowCount.

Hi,
Wainting for your replay.
Thanks.
Four Stars

Re: Error in tFileRowCount.

Hi vinu,
Your file is of .xlsx, excel input file component has a check box to read .xlsx file... enable that check box...
rowcount is not supported in .xlsx file... may be you can convert that file to xls and then read again same file and display its count using tjava.
Thanks
Vaibhav
Four Stars

Re: Error in tFileRowCount.

Hi Vinu,
If you still want to get the count, insert tjavarow component, define a cnt as a context variable. Write following code in tJavarow component.
context.cnt=context.cnt+1
After completing the job, display context.cnt... it will show you the row count.
Thanks
Vaibhav

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch