I'm stanardising several files so I can combine them, but I want to ignore the first several rows on each

[mickyd67]

Hi all,

Hope I'm in the right place. I am working on a standard set of files for my colleagues - with the aim being we can pull all the data into one place.

I can use Get Data and transform the data into a single file.

However each individual file has 6 rows of data (headings and other various info) - I basically want the query to pull the data in from each file from Row 7

Is that possible?

Thanks
M

 

[sandy666]

maybe Table.Skip(previous_step, 6)

 

[mickyd67]

maybe Table.Skip(previous_step, 6)

Thanks Sandy - where would I put this text? (Hopefully an easy answer... )

 

[sandy666]

first I need to know:
- all files have the same structure and type of data?
- how files are loaded: From Folder or each file individually?

 

[mickyd67]

Hi Sandy - all the files are exactly the same layout (all the data I need to combine is from Row 7 down), I am pulling them together from a folder.

 

[sandy666]

after combine and edit
on the left side you will see

so select green marked step and on the right side add step

which is just : Table.Skip(#"Promoted Headers",6)
it will skip 6 top rows from each file

 

[mickyd67]

Great - thanks Sandy. I'll give that a try.

 

[sandy666]

sure, let me know if it works for you