For some reason, I'm getting this error message when I try to query a particular column from a table using custom Sql. My query is (Select sales, margin ($) from ordersinvoiced_cono1). Margin ($) is one of the column names of that table.

@AllenRajiv Masilamani​ 

Hi, I would recommend to use alias:

Select [sales] AS Sales,
[margin ($)] AS Margin
FROM ordersinvoiced_cono1

also, check if the column name in the sql table ordersinvoiced_cono1 is margin ($) (I don't think it is).

I would recommend to clear your connection window, drag and drop the table ordersinvoiced_cono1, then clic on the Data Menu and Convert to SQL. Start working from there.

If this post resolves the question, would you be so kind to "Select as Best"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.

Regards,

Diego

Tableau Ambassador