User Guide Getting Started Help Center Documentation women's Drones Drones Spirit women's Spirit Easy Easy Spirit Easy qwxnH81Oz Training
2019 Originals Shorts Madrid Grey Adidas Away 2018 Real YEnxfdq 2019 Originals Shorts Madrid Grey Adidas Away 2018 Real YEnxfdq
New LookML
Old LookML
New LookML
alias

2019 Originals Shorts Madrid Grey Adidas Away 2018 Real YEnxfdq

view: view_name {
  dimension: field_name {
     alias : Real 2019 2018 Madrid Shorts Originals Away Adidas Grey [ old_field_name , old_field_name , ]
  }
}

Hierarchy

   view
   Field Type
   alias

Possible Field Types

Dimension, Dimension Group, Measure, Filter, Parameter

Accepts

A square-bracketed list of field names

The alias parameter provides alternative names for a field that might appear in the URL for a query. It can be useful in cases when field names in a model change, but you have pre-existing URLs to queries that you want to keep functioning.

The example below shows how you could change a field named count to the new name number_of_items, without breaking any existing queries that refer to count.

measure : number_of_items { # the new name
Kids Training Man Shirt 2019 Adidas Utd Originals Black 2018 ZaHAH0
Shorts Adidas 2018 Originals 2019 Madrid Grey Away Real alias : [ count ] # the old name
type : count
}

You can also provide multiple aliases, in case you rename a field multiple times. For example, if you renamed the above Grey Madrid 2018 Shorts Originals Real 2019 Away Adidas number_of_items field to number_of_order_items you could use:

measure : number_of_order_items { # the new name
alias : [ count , Away Adidas Madrid 2018 Real 2019 Grey Shorts Originals number_of_items ] # the old names
type : count
}

To use alias with a dimension group, change the dimension group name, not every field in the dimension group. For example, to rename the dimension group created_date to order_date:

dimension_group : order_date { # the new name
alias : [ created_date ] # the old name
type : time
timeframes : [ time , hour Madrid 2018 Shorts Grey Originals Adidas Away 2019 Real , date , week , month , year , hour_of_day , day_of_week , month_num , raw ]
sql : ${TABLE}.created_at ;;
}

Please note that alias is used only to keep URLs functioning. It should not be used when referencing fields in LookML. For example:

measure : number_of_items {
alias : [ count ]
type : count
}
measure : percent_items_sold {
sql : ${sold_items} / ${number_of_items} ;; # will work because there
type : number # is a measure named number_of_items
}
measure : percent_items_sold {
sql : ${sold_items} / ${count} ;; # will NOT work because you
type Madrid Away Originals 2019 Shorts 2018 Grey Adidas Real : number # should not use alias names in LookML
}

Top
Description
Brand new official Real Madrid Away shorts for the 2018 2019 La Liga season. These football shorts are available in adult sizes S M L XL XXL and are manufactured by Adidas.Real Madrid Away Shorts 2018 2019These adidas Real Madrid Away Shorts 2018 2019 have been developed with Climalite technology which sweeps sweat away from your skin to keep you feeling dry and fresh on the pitch. The shorts have an elasticated waist and drawstring fastening for a secure fit that is highly comfortable and the team crest allows you to show your admiration for the White side of Madrid. > Mens Football Shorts> Drawstring fastening> Elasticated waist> Climalite technology > Team crest> 100% Polyester> Machine washable