Hi guys,
I have a custom code running in Power Query that I got from a closed thread in another forum, and I can't figure this error out. It worked fine on the file from other forum.
Code is
let
Source = Excel.CurrentWorkbook(){[Name="Table5"]}[Content],
#"Added Custom" = Table.AddColumn(Source, "Custom", each Text.Repeat("a,",[VARIATION COUNT FIXED]-1)&"a"),
#"Split Column by Delimiter" = Table.ExpandListColumn(Table.TransformColumns(#"Added Custom", {{"Custom", Splitter.SplitTextByDelimiter(",", QuoteStyle.Csv), let itemType = (type nullable text) meta [Serialized.Text = true] in type {itemType}}}), "Custom"),
#"Removed Columns" = Table.RemoveColumns(#"Split Column by Delimiter",{"Custom"})
in
#"Removed Columns"
Error comes back at me saying "we cannot apply operator - to types text and number".
Please help!
Thanks
Logan
Bookmarks