Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Error 3521

cyoung3
6 - Meteoroid

Hi, 

I am getting the following error "Error 3521: Improper Qualified Name (too many dots). I have not seen any other errors like this, but was  wondering if any one has ran into it? I have taken all alias's out of my query and am still getting the same error. 

2 REPLIES 2
CharlieS
17 - Castor
17 - Castor

Hi @cyoung3 

 

Could you share some more context? This is from a query, but are you using the Input tool? to SQL Server? Can you share the query?

 

Have you tried putting the table name in quotes as suggested in this post?
https://stackoverflow.com/questions/51307067/periods-in-table-names-causing-errors 

Qiu
20 - Arcturus
20 - Arcturus

@cyoung3 


As @CharlieS suggested, it happens maybe because you are not quotating table name with Non-standard identifiers.

 

https://stackoverflow.com/questions/51307067/periods-in-table-names-causing-errors
As documented in the manual in SQL, non-standard identifiers have to be quoted with double quotes:


 

Labels