I have a set of excel files inside ADLS. The format looks similar to the one below:
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?