Business iQ (Analytics)

cancel
Showing results for 
Search instead for 
Did you mean: 

Analytical ADQL query

SOLVED

Analytical ADQL query

I am looking for an analytical query to fetch list of URLs from browser records that does not match a pagename  with http and without http and with partial URL segments...

 

example : select * from browser records where pagename is not in ("abc.com", "https://abc.com",%abc.com%) 

 

 

Tags (1)
Analytical ADQL query
1 REPLY 1
Mario.Morelli
Architect

Re: Analytical ADQL query

Hi @Rathinakararaj.Sundaraj 

 

Can you not use something like below?

 

SELECT * FROM browser_records WHERE pagename not like "*abc.com*"

 

Ciao



Learn more about me in the Community Member Spotlight Q & A