Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

An object or column name is missing or empty. SqlServer

Hi when i try to do the ETL PRocess i get this :
An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.
this is the Query that i use :
select distinct(FechaEmision) as fecha, MONTH(FechaEmision) as mes, YEAR(FechaEmision) as año from ReciboCompra
i use the Version: 5.3.0
Thanks !
Labels (2)
1 Reply
Anonymous
Not applicable
Author

I am pretty sure your alias año is not allowed. I would avoid using language specific characters and write as alias in this case ano even it sounds not pretty in Spanish (?)