Forum Discussion
how to Skip top Row in Mquery
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
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]))
2 Replies
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]))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.
