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
• 12,240 points
20 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
• 20,880 points

Related Questions In Others

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
75 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
71 views
0 votes
1 answer

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

Hi To Calculate the date, we can ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
114 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

Feb 17 in Others by Edureka
• 13,640 points
62 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,574 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
300 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,826 views
0 votes
1 answer

Unable to import data in excel from another website using VB code

Replace : Set ieTable = ieDoc.all.Item("report-table") With: Set ieTable = ...READ MORE

answered Sep 21 in Others by narikkadan
• 20,880 points
17 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