Forum Discussion

Junaid11's avatar
Junaid11
Helper V
4 years ago
Solved

Special Character in Column Name

Hello, I have few columns which have special characters in them. I tried creating a custom column based on column with special character in its name but it did not allow me to do that in Power query...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    [#"Work?"] instead of [Work?] will work.

     

    --Nate

Danalber's avatar
Danalber
Advocate II
3 years ago

Hi,

I had a similar issue today and the solution above didn't work. After many try and errors the solution in my case was very easy.

In the power query the column name with the special character, "#" in my case, just needed to be set in a double quote.

 

SELECT TRANSACTION_ID, TRANSACTION_TYPE, ""COMMENTS#1"" FROM PROD_DB.PO.RCV_TRANSACTIONS

 

The single quote '' and squared brakes [] both didn't work in the power query.

Hope this might be useful to someone at some point. Wasted quite a bit time today. 🙂

BR