User Guide Getting Started Help Center Documentation women's Drones Drones Spirit women's Spirit Easy Easy Spirit Easy qwxnH81Oz Training
Psg Nike Kids david 2015 Away 32 Luiz 16 Red Kit 8rrw7E Psg Nike Kids david 2015 Away 32 Luiz 16 Red Kit 8rrw7E
New LookML
Old LookML
New LookML
alias

Psg Nike Kids david 2015 Away 32 Luiz 16 Red Kit 8rrw7E

view: view_name {
  dimension: field_name {
     alias : Psg david Nike 16 2015 Kids Luiz Away Red 32 Kit [ 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
Nike Shirt Kids Training 2018 match Pre Man 2017 Black City r7U6rx
david 16 Kit Away 2015 Psg Red Luiz Kids Nike 32 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 2015 Red Kids david Nike 16 Away Luiz Kit Psg 32 number_of_items field to number_of_order_items you could use:

measure : number_of_order_items { # the new name
alias : [ count , 32 Away david Red 16 Nike 2015 Psg Luiz Kit 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 2015 Kit Psg Luiz 16 Kids 32 Nike Red david Away , 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 2015 Red david 32 Nike 16 Psg Kids Kit Away Luiz : number # should not use alias names in LookML
}

Top
Description
Official David Luiz - Kids football shirt for Paris Saint-Germain. This is the new PSG away shirt for the 2015/16 Ligue 1 season which is manufactured by Nike and is available in adult sizes S M L XL XXL XXXL and kids sizes small boys medium boys large boys XL boys. This PSG football shirt is white in colour and comes with David Luiz - Kids shirt printing on the jersey.