Log In
Register
Home
Power Pivot
September 2, 2020
Offline
We have to combine several data files, coming from our time & attendance system.
The exported files are saved in a SharePoint- or OneDrive-folder, and contain starting rows 'describing' the selection criteria.
Is there a possibility to combine these files and automatically remove the starting 12 rows of each file?
Kind regards,
Maarten
See Answer
July 16, 2010
Offline
Hi Maarten,
If you get files from a SharePoint list you can then combine them and then in the Query Editor go to the 'Transform Sample File' query and on the Home tab use Remove Rows > Remove Top Rows to remove the top 12 rows.
Then in the Query under 'Other Queries' you'll see the consolidated files with the first 12 rows removed from each file.
Mynda
Answers Post
Power Pivot
September 2, 2020
Offline
Hi Mynda,
Thanks.
Unfortunately in a Dutch environment all these names are different.
So I had to search some time getting the right place to correct, but I managed.
Regards,
Maarten
1 Guest(s)
