In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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
21 - Polaris
21 - Polaris

@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
Top Solution Authors