When defining aliases, keep in mind the following considerations:
- Within a given query, each alias must be unique. If you specify an alias that has already been defined for another column in the same query, a number will be appended to the end of each duplicate alias to distinguish them from the other aliases in the query. For example, if you specify Asset as the alias in four columns, the aliases would be changed to:
- Asset
- Asset0
- Asset1
- Asset2
Each duplicate alias will be numbered in this way using the next available number (i.e., 3, 4, 5, and so on).
- The alias cannot exceed 27 characters in length (including spaces). You will not be able to enter more than 27 characters into any Alias cell.