Forum Discussion
incorrectly creating new lines
In my csv found this data have enter so its show new lines can i slove this issue 1. I replace value enter to "," but i cannt slove it 2.I setting show that pic 2 I cannt solve it can ...
Hi Anonymous
let
Source = Csv.Document(Parameter3,[Delimiter=",", Columns=21, Encoding=65001, QuoteStyle=QuoteStyle.None]),
#"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true])
in
#"Promoted Headers"
Its sample file
let
Source = SharePoint.Files("
https:xxx/"
, [ApiVersion = 15]),
#"Filtered Rows" = Table.SelectRows(Source, each ([Folder Path] = "https://xxx/")),
Navigation1 = #"Filtered Rows"{0}[Content]
in
Navigation1