Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version r095

D toc

Excerpt

Finds the value for the domain from a valid URL. Input values must be of URL or String type.

In this implementation, a domain value is all data between 1) the protocol identifier (if present) and the sub-domain and 2) the trailing, top-level domain information (e.g. .com).

Info

NOTE: When the DOMAIN function parses a multi-tiered top-level domain such as co.uk, the output is the first part of the domain value (e.g. co). To return other parts of the domain information, you can use the HOST function. See HOST Function.

D s lang vs sql

D s
snippetBasic

URL literal examples:

D lang syntax
RawWrangletrue
Typeref
showNotetrue
WrangleTextderive type:single value:domain('http://www.example.com' ) as: 'myDomain'

domain('http://www.example.com')


Output:
Returns the value example

D lang syntax
RawWrangletrue
Typeref
showNotetrue
WrangleTextderive type:single value:domain('http://www.exampl.e.com' ) as: 'myDomain'

domain('http://www.exampl.e.com')

Output: Returns the value e

Column reference example:

D lang syntax
RawWrangletrue
Typeref
showNotetrue
WrangleTextderive type:single value:domain(myURLs) as: 'myDomain'

domain(myURLs)

Output: Returns the domain values extracted from the myURLs column. 

D s
snippetSyntax

D lang syntax
RawWrangletrue
Typesyntax
showNotetrue
WrangleTextderive type:single value:domain(column_url)

domain(column_url)


ArgumentRequired?Data TypeDescription
column_urlYstringName of column or String or URL literal containing the domain value to extract

D s lang notes

column_url

Name of the column or URL or String literal whose values are used to extract the domain value.

  • Missing input values generate missing results.
  • Multiple columns and wildcards are not supported.

D s
snippetusage

 

Required?Data TypeExample Value
YesString literal or column reference (URL)http://www.example.com

D s
snippetExamples

Example - Filter out internal users

Here is some example web visitor information, including the name of the individual and the referring URL. You would like to filter out the internal users, whose referrer values include test-value.

NameReferrer
Joe Guyhttp://www.example.com
Ian Holmeshttp://www.test-value.com/support
Nick Knight http://www.test-value.com
Axel Adams http://www.example.com
Teri Towns http://www.example.com/test-value

Transformation:

The referrrer values include test-value as a non-domain value and varying URLs from the test-value.com domain. So, you should use the DOMAIN function to parse only the domain versions of these values. The following evaluates the Referrer column values for the test-value domain and generates true/false answers in a new column accordingly:

D trans
RawWrangletrue
p03Value'isInternal'
Typestep
WrangleTextderive type:single value:if(domain(Referrer)=='test-value',true,false) as:'isInternal'
p01NameFormula type
p01ValueSingle row formula
p02NameFormula
p02Valueif(domain(Referrer)=='test-value',true,false)
p03NameNew column name
SearchTermNew formula

Now that these values are flagged, you can filter out the internal names:

D trans
RawWrangletrue
p03Value(isInternal == 'true')
Typestep
WrangleTextdelete row:(isInternal == 'true')
p01NameCondition
p01ValueCustom formula
p02NameType of formula
p02ValueCustom single
p03NameCondition
p04ValueDelete matching rows
p04NameAction
SearchTermFilter rows

Results:

NameReferrerisInternal
Joe Guyhttp://www.example.comfalse
Axel Adamshttp://www.example.comfalse
Teri Townshttp://www.example.com/test-valuefalse

Example - Domain, Subdomain, Host, and Suffix functions

Include Page
EXAMPLE - Domain Functions
EXAMPLE - Domain Functions

D s also
labelother