Power Query .csv top lines remove from each file

[srehman]

I need to extract multiple csv file by Power query , but i don't need top 6 lines from each csv file. I need only column header and respective data which start from line 7.

I am using following functions but rest of data showing as an error

Csv.Document([Content])
Table.PromoteHeaders([Custom])

 

[Alex Blakenburg]

Try this:

In the left pane of your Power Query editor, you should have an item that says "Transform Sample File".

Select that and then go Home > Remove Rows > Remove Top Rows > enter a number of rows - 6 in this case.

Go back to the Main Query under Other Queries before promoting the header.

 

[srehman]

Gr8 i just did same way all good now

 

[srehman]

Try this:

In the left pane of your Power Query editor, you should have an item that says "Transform Sample File".

Select that and then go Home > Remove Rows > Remove Top Rows > enter a number of rows - 6 in this case.

Go back to the Main Query under Other Queries before promoting the header.


View attachment 38026

="10000182" some columns data with ="" i can replace value but why is showing like that

 

[srehman]

="10000182" some columns data with ="" i can replace value but why is showing like that

 

[Alex Blakenburg]

You might need to log this as a separate query and if you provide the link I can have a look.

Step 1 is to see if you can figure out which of you csv files is causing this (or at least one of them), then open it in Notepad and try a Find for the = sign.
If its in the csv file then Power Query will bring it in the way it is and you need to address it at the source (creation of csv file stage)

If you can't work it out from that then we need some sample data that is causing the problem to work with.

 

[Alex Blakenburg]

Gr8 i just did same way all good now

Thanks for letting us know, happy to help.

 

[srehman]

Thanks for letting us know, happy to help.

Ye it is in csv file like that ="TUB 1A" so i replaced value after transformed. Got the results.
Much appreciated your support thanks

 

[Alex Blakenburg]

No worries, glad it was as straight forward as that.