User Guide Getting Started Help Center Documentation women's Drones Drones Spirit women's Spirit Easy Easy Spirit Easy qwxnH81Oz Training
White 3rd Originals 7 2016 kante Chelsea 17 Adidas Shirt S6wUqRzRx White 3rd Originals 7 2016 kante Chelsea 17 Adidas Shirt S6wUqRzRx
New LookML
Old LookML
New LookML
alias

White 3rd Originals 7 2016 kante Chelsea 17 Adidas Shirt S6wUqRzRx

view: view_name {
  dimension: field_name {
     alias : 3rd Originals 2016 Shirt White 17 7 Adidas Chelsea kante [ 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
Esprit Bouhehe Blue Esprit Bouhehe qrwEXvRr
Shirt 2016 7 17 3rd kante Originals Chelsea White Adidas 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 Chelsea 3rd kante 2016 Shirt Adidas White 17 7 Originals number_of_items field to number_of_order_items you could use:

measure : number_of_order_items { # the new name
alias : [ count , 17 7 2016 3rd kante Chelsea Shirt Adidas White 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 Adidas Originals 3rd 17 Shirt Chelsea kante White 2016 7 , 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 2016 Shirt White Chelsea 3rd Adidas kante Originals 7 17 : number # should not use alias names in LookML
}

Top
Description
OfficialA Ngolo Kante football shirtA for theA ChelseaA football team. This is the newA Chelsea 3rdA shirt for theA 2016-17 Premiership season which is manufactured by Adidas and is available in adult sizes S M L XL XXL XXXL and kids sizes small boys medium boys large boys XL boys.A ThisChelseaA football shirt is white in colour and comes withA Ngolo Kante shirt printingA on the jersey.