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 ERNER2000 ,
We really can't tell what's wrong just by looking at the screenshots. Can you replace the data in your csv with sample data and provide it to us? That way maybe we can run some tests in order to find a solution, thanks!
Best Regards,
Dino Tao
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