casegroupinglooker-studio
How to group things in Looker Studio with "but not" condition?
In Looker Studio I have two types of urls, which I want to group. URLs are categories and articles looking like:
https://example.com/category1/
https://example.com/category1/article_abc
https://example.com/category2/
https://example.com/category2/article_xyz
I thought about using in the CASE a kind of the following expression:
CASE
WHEN URL ENDS_WITH "category1/" THEN "category1 folder"
WHEN URL COMTAINS "category1" BUT NOT ENDS_WITH "category1/" THEN "category1 url"
END
But I'm pretty sure, that this part with BUT NOTwill not work. What is the right way? Should I maybe make USE of REGEX_MATCH? Like
CASE
WHEN REGEXP_MATCH(URL, "category1\/$") THEN "category1 folder"
WHEN REGEXP_MATCH(URL, "category1\/.+?") THEN "category1 url"
END
Solution
You may try:
CASE
WHEN REGEXP_CONTAINS(URL, "category1/$") THEN "category1 folder"
WHEN REGEXP_CONTAINS(URL, "category1/.+") THEN "category1 url"
END
- VHDL signal not assigned in every case statement
- Create a variable that increases by one in every row but resets based on condition
- sum case with left join
- Difference if_else (returning too long vector) and case_when when using dplyr
- Transact SQL, GROUP BY using Case with aggregate function
- Using a custom case_when function in dplyr mutate
- Selecting grouped samples satisfying desired conditions
- Microstrategy Apply Simple with Certain Text
- SQL : How to subquery using outer alias with case expression
- find users with overlapping subscription dates
- Redshift CASE filter has unexpected behaviour with integer values
- Convert string to Pascal Case (aka UpperCamelCase) in Javascript
- ORDER BY on INT column inside CASE expression not working properly
- Column names in GROUP BY and ORDER BY
- How to add ANY operator into an AVG in CASE SQL
- Modify the values of a variable
- Whats wrong with my query with CASE statement
- SQL Server: use CASE with LIKE
- JOIN and CASE WHEN - How to check for NULL and use that field to join 2 tables?
- Sum Case when statement using Condition 1 minus Condition 2
- In R create a new column from a column using the function case_when() with multiple conditional rules
- Multiple case and conditions
- How do you test inequality with Oracle Case Statement
- How to modify query run based on the day of the week?
- How can I make a Case_when with dynamic conditions to modify a continuous vector into ordinal vector of numbers in R?
- How to reassign values based on grouping and dates (R)
- Problem with Case Select is too slow after 35 variables
- VBA copy data from workbook to another based on criteria
- SQL Query CASE Clause when > 180 days between TransactionDate for same MemberNumber
- Not equals when using CASE statement in SQL