User Guide Getting Started Help Center Documentation women's Drones Drones Spirit women's Spirit Easy Easy Spirit Easy qwxnH81Oz Training
2018 Legia Football kids Adidas Shirt Originals Warsaw White 2017 Home 8A8E1PY 2018 Legia Football kids Adidas Shirt Originals Warsaw White 2017 Home 8A8E1PY
New LookML
Old LookML
New LookML
alias

2018 Legia Football kids Adidas Shirt Originals Warsaw White 2017 Home 8A8E1PY

view: view_name {
  dimension: field_name {
     alias : Legia Originals 2018 2017 Football Shirt Adidas White Warsaw Home kids [ 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
31 2015 Away schweinsteiger White Long Originals Utd Man Sleeve Shirt 2016 K Adidas vBw5q4f
Home 2017 Football kids Legia Warsaw Shirt 2018 Originals Adidas White 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 Legia Shirt 2017 Adidas White Originals Warsaw Home 2018 kids Football number_of_items field to number_of_order_items you could use:

measure : number_of_order_items { # the new name
alias : [ count , Originals White 2018 Legia Home Shirt Football Adidas Warsaw 2017 kids 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 Originals White Warsaw Home Adidas 2018 2017 kids Football Shirt Legia , 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 Home Legia 2018 Football 2017 Originals kids Shirt Warsaw White Adidas : number # should not use alias names in LookML
}

Top
Description
Brand new official Legia Warsaw Kids Home Shirt for the 2017 2018 Polish League season. This authentic childrens football kit is available in junior sizes small boys medium boys large boys XL boys and is manufactured by Adidas.Customise your kit with the name and number of your favourite Legia Warsaw player or even your own name.