Forum Discussion

PowerBeeEye's avatar
PowerBeeEye
Microsoft Employee
5 years ago

Promote headers within Csv.Document

I have multiple CSV files I am trying to combine in a query. I am trying to do this without a function. Two issues I am running into: Empty cells - these throw the next row out of what. I was abl...
Need Help
IvanRy's avatar
IvanRy
New Member
3 years ago

Maybe it will be helpful for other people, just wrap yor Csv.Document() with Table.PromoteHeaders like this:
= Table.AddColumn(#"Removed Other Columns", "Custom", each Table.PromoteHeaders(Csv.Document([Content])))

marvel25's avatar
marvel25
Regular Visitor
2 years ago

This is the correct answer.