extend operator creates calculated columns and appends them to the result set.
To create a new column (
is_female), use the query below:
Loading APL Editor...
Here are a few other examples to try:
extend get_specific_month = getmonth(birth_date)
extend IsIPv4Prefix = ipv4_is_in_range(ip_address) == true
extend returns_clock_time = now(-5d)
To learn more, see the extend docs.