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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
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 (?)