Fetch Line_Number from Excel file using Talend

AbhishekBoga — Fri, 17 May 2019 11:38:53 GMT

Hi All,

This is my first post and hope so expecting a positive response on my query.

I am working on a requirement where I have to extract data from Excel, convert into CSV then convert into JSON and than load into snowflake table. I am able to achieve all above things but where I stuck on below 2 things :

1. How to fetch excel line_number from each sheet in a single excel file.

2. Read all Line_number from all the sheet of a single CSV file

Find the attached screenshot where i want to read excel line_number (Attachment name: "Excel Line Number" hightlighted in blue which starts from 2) and create a CSV file. So let's say an Excel File is having 3 sheets, each having 10 records, so my final CSV should look like as per the attachment (name: "Target CSV File")

I hope my requirement is clear to understanding the query. Please let me know how i can achieve this handling.

Re: Fetch Line_Number from Excel file using Talend

Anonymous — Fri, 17 May 2019 13:31:40 GMT

Hello

I suggest tJavaRow to implement line numbers

Find attached a sample job

talendJob.zip

Re: Fetch Line_Number from Excel file using Talend

AbhishekBoga — Tue, 21 May 2019 09:50:21 GMT

Thanks dgm01.

Your solution worked for me...

topic Re: Fetch Line_Number from Excel file using Talend in Talend Studio

Fetch Line_Number from Excel file using Talend

Re: Fetch Line_Number from Excel file using Talend

Re: Fetch Line_Number from Excel file using Talend