Removing specific rows in an Excel file using Azure Data Factory

0 votes

I have a set of excel files inside ADLS. The format looks similar to the one below:

enter image description here

The first four rows of a document are always the header information, and the final three rows are two empty rows and a marker marking the conclusion of the page. There are an undetermined amount of rows for the employee data. Using ADF, I want to remove the first four rows and the final three rows.

Can any help me with what should be expressions in the Derived column / Select?

Sep 22 in Others by Kithuzzz
• 20,660 points
189 views

1 answer to this question.

0 votes

Under the 'Source' tab, choose the number of lines you want to skip.

enter image description here

answered Sep 23 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer

How do delete an specific page in a word document using Excel VBA?

Check the code below. I eliminated the ...READ MORE

answered 6 days ago in Others by narikkadan
• 37,660 points
15 views
0 votes
1 answer

How can I store the data of an open excel workbook in a collection using BluePrism?

To do what you want is like ...READ MORE

answered 4 days ago in Others by narikkadan
• 37,660 points
10 views
0 votes
1 answer

Spell number in excel 2013 using 2 rows

Hello, there are a few steps to ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
103 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
139 views
0 votes
1 answer

Azure Data factory : Pipeline data flow execution fails.

This error usually occurs when dataset contains ...READ MORE

answered Jan 2, 2020 in Azure by Sirajul
• 59,190 points
1,655 views
0 votes
1 answer

How can I schedule a pipeline to run in azure datafactory?

You can use the scheduler trigger or ...READ MORE

answered Jan 2, 2020 in Azure by Sirajul
• 59,190 points
316 views
0 votes
2 answers

What is integration runtime in azure data factory?

IR is like act as brige between ...READ MORE

answered Feb 22, 2020 in Azure by yahya sharif
4,956 views
0 votes
1 answer

Create Graph from data in an excel file

Your first step would be to become ...READ MORE

answered Oct 17 in Others by narikkadan
• 37,660 points
37 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP