Forum Discussion
Helper IHow can i import a csv starting with row 2?
Hello,
I have a CSV which i have to edit every day.
In the first row there are some status informations and they are not relevant for the table.
at row 2 the table starts.
But how can i import this in powerquery.
Now my workaround is:
- open it in open office
- remove first row
- import it with powerquery
but is there a better way?
thank you!
2 Replies
ElenaNResolver V
Hello,
You can use the function Table.Skip to remove first needed rows. (after loading the initial/unmodified file in Power Query)
https://docs.microsoft.com/en-us/powerquery-m/table-skip
Regards,
ElenaN
- MFelix
Super User
Hi n8schicht ,
The answer given by ElenaN is a great option but I'm assuming you are not proeficcient in query editor and advance editing, best option would be to just filter out the row 2 from your dataset, when it's uploaded to the model it will only return the last step of your query.
Regards,
MFelix
