how to Skip top Row in Mquery

[RAKESH1986]

Hi,

could you help me how i can remove this top row.. i have multiple files and I want to remove top row to make next line as header.

thanks

rakesh

[HotChilli · Accepted solution]

You are on the right track.

Anything you can do to a table, you can do to a table when it's a row in a list.  So if you create a test table in another query, you can get power query to generate the syntax for you.

In this case you want

Table.PromoteHeaders(_ , [PromoteAllScalars=true]))

[KeyurPatel14]

Hi @RAKESH1986 ,
You can use Table.PromoteHeaders inside your function.
I hope this will solve your problem and if this helps you then please give it a kudos and accept it as a solution.
Thank you.