The 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...

No query result to show, please click the 'run query' button above!

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.

Was this page helpful?