ilcaa
New member
- Joined
- Jun 15, 2018
- Messages
- 10
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2016
i am trying to split a column if the condition are true in another column. i keep getting errors in my M Code
Code:
let
Source = Csv.Document(File.Contents("C:\Users\MTS\Documents\Activity Dec 2018.csv"),[Delimiter=",", Columns=7, Encoding=1252, QuoteStyle=QuoteStyle.None]),
#"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
#"Split Column by Position" = Table.SplitColumn(#"Promoted Headers", "Description", each if [Type] = "BILLPAY" then Splitter.SplitTextByPositions({0, 29}, false) else null, {"Description.1", "Description.2"} )
in
#"Split Column by Position"