I have a query that has two native fields, they are "referenced_host" and "url".
I performed the extraction of the "referenced_host" field by naming it as the domain.
The problem is that the domain field comes empty whenever the URL field contains "HTTPS" values.
"Referenced_host" field value = ctldl.windowsupdate.com
Domain field value = ctldl.windowsupdate.com
URL field value = http://ctldl.windowsupdate.com/msdownload/update/v3/stati (...)
Referenced_host field value = null
Domain field value = null
URL field value = https://www.facebook.com
Would I have to make the domain field assume the value of the URL field, every time the URL field has values beginning with "HTTPS"?
Extraction of the domain field was done based on the referenced_host field.
It turns out that every time the URL field comes with "HTTPS" the referenced_host field is empty, making the domain field also empty.
I need every time the URL field has values with "HTTPS" the domain field assumes this value and every time the URL field comes with "HTTP" values the domain field assumes the values of the referenced_host field.