Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

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 "...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi,

    Thanks for the solution ZhangKun  and jgeddes  offered, and i want to offer some mroe information for user to refer to.

    hello Anonymous , you can click the 'Accout Name' and 'Postcode' columns,  then click merged columns in 'Add column' tab

    Then select split them by using the space.

     

    Output

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

jgeddes's avatar
jgeddes
Icon for Super User rankSuper User
1 year ago

Adding 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.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Thanks jgeddes for providing a responce with a sample code. Strangely I still get error - see screenshot-1 (same syntax error as before) when I try to add new column, or to transform an existing column (screenshot-2): invalid identifier. 

 

Revised code used:
Add: = Table.AddColumn(#"Renamed Columns", "Trader Uid", each [Account Name] & Text.Clean([Postcode]), type text)
Transform: = Table.TransformColumns(#"Renamed Columns", {{"Trader Uid", each [Account Name] & " " & Text.Clean([Postcode]), type text}})