Forum Discussion
Need help to correct a syntax error in my power query formula
Admitedly I am new to Power Query, I am trying to cleanse an internal database full of duplicate entries. I'm currently stuck at this step to transform the data. Problem: I'm encountering an "...
jgeddes
Super User
Super UserAdding a column should have the code...
Table.AddColumn(previousStepName, "Trader Uid", each [Account Name] & Text.Clean([Postcode]), type text)In your code you appear to be attempting to transform an existing column. I would guess the error in your code is due to {Account Name}. It should be [Account Name].
Hope this helps.