Remove Rows in TXT file

oluskaaa123
Posts: 1
Joined: Fri Mar 15, 2019 7:30 am

Remove Rows in TXT file

Postby oluskaaa123 » Fri Mar 15, 2019 7:35 am

Hiya
I am newbie to Power Query but I want to expand my knowledge. Currently I am working on the exporting data from TXT file into excel. Honestly I am stuck in a moment where I have to remove first 20 lines of the txt file. What is crucial that I am gonna to import more than one file but the structer of txt file is always the same. So I need to have always errased the first 20 line. Any suggestions?
I really appreciate any answers.
Best.
Al

PhilC
Posts: 235
Joined: Tue Sep 09, 2014 8:13 am

Re: Remove Rows in TXT file

Postby PhilC » Mon Mar 18, 2019 8:30 am

Hi oluskaaa123,

Below are a few links to show you how to combine multiple files from a folder in Power Query.

https://powerpivotpro.com/2015/01/power ... ile-types/

https://www.myexcelonline.com/blog/cons ... wer-query/

https://powerpivotpro.com/2018/05/power ... r-combine/



If you want to remove the top 20 rows, that is a simple transformation using "Remove Rows" (which is on the Home menu), and entering 20 rows. Just add this into the template that is created when setting up the extraction and it will happen for all the files.

Cheers
Phil


Return to “Power Query”

Who is online

Users browsing this forum: No registered users and 1 guest