Forum Discussion
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...
Why trying to avoid using a function? It is the way to do this one. You can create the function within the same query if needed.
Also, you can use Csv.Document to get your column of tables (one for each file), and then use a table function to remove the top row of each before expand/append the tables (but maybe it is too late by then?).
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat