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, 2022 in Others by Kithuzzz
• 38,010 points
2,175 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, 2022 by narikkadan
• 63,700 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 Nov 21, 2022 in Others by narikkadan
• 63,700 points
1,196 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 Nov 24, 2022 in Others by narikkadan
• 63,700 points
1,000 views
0 votes
1 answer

How to save a new sheet in an existing excel file, using Pandas?

import pandas as pd import numpy as np path ...READ MORE

answered Dec 10, 2022 in Others by narikkadan
• 63,700 points
6,862 views
0 votes
1 answer

How can I count the rows with data in an Excel sheet?

With formulas, what you can do is: in ...READ MORE

answered Dec 27, 2022 in Others by narikkadan
• 63,700 points
407 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,230 points
2,511 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,230 points
716 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
5,988 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, 2022 in Others by narikkadan
• 63,700 points
659 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