Forum Discussion
CSV column format changed, How to adapt??
Hi I used combine function in power query to combine multiple CSV from sharepoint folder together. I used the sample file transformation - it was working like a charm untill recently - the company w...
For whoever's still looking for a solution, after all this time. There is a custom function created to support the csv file import, that relies on a sample query. This sample query holds the number of columns to be imported. It should be named something like "File Transform Sample" (translating from Portuguese), and it's structure should be like:
let
Fonte = Csv.Document(Parâmetro1,[Delimiter=";", Columns=15, Encoding=1252, QuoteStyle=QuoteStyle.None]),
#"Cabeçalhos Promovidos" = Table.PromoteHeaders(Fonte, [PromoteAllScalars=true])
in
#"Cabeçalhos Promovidos"
The trick is changin the "Columns" to reflect the correct number of columns on your new CSV file.
Hope that helps