How to write a function that returns positive if function contains values from another column?

The title is a little confusing, but basically I want to write a function like this:
CASE
WHEN `Track Split` LIKE '%AZ%' THEN 'AZ'
end
EXCEPT, instead of basing it off of a string, I want it to pull values from another column. I have a lot of changing data from row to row, so I want the row to check to see if the data contains a specific value from a separate column so I don't have to write a ton of different strings. Something like:
CASE
WHEN `Track Split` LIKE %`Library`% THEN 'AZ'
But that's clearly not working. Does anyone have any suggestions?
Best Answers
-
Try something like this:
CASE WHEN `Track Split` LIKE CONCAT(CONCAT('%', `Library`), '%') THEN 'AZ' END
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 -
@ljb18 Since you're trying to determine whether the value of the
Library
column exists within theTrack Split
column, you could also try using the INSTR function to return the position of theLibrary
value. If there is a match then the position will be greater than 0.case when INSTR(`Track Split`,`Library`) > 0 then 'AZ' end
0
Answers
-
Try something like this:
CASE WHEN `Track Split` LIKE CONCAT(CONCAT('%', `Library`), '%') THEN 'AZ' END
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 -
@ljb18 Since you're trying to determine whether the value of the
Library
column exists within theTrack Split
column, you could also try using the INSTR function to return the position of theLibrary
value. If there is a match then the position will be greater than 0.case when INSTR(`Track Split`,`Library`) > 0 then 'AZ' end
0 -
That worked perfectly, thank you so much!
0
Categories
- All Categories
- 1.1K Product Ideas
- 1.1K Ideas Exchange
- 1.2K Connect
- 970 Connectors
- 259 Workbench
- Cloud Amplifier
- 1 Federated
- 2.4K Transform
- 76 SQL DataFlows
- 502 Datasets
- 1.8K Magic ETL
- 2.7K Visualize
- 2.2K Charting
- 379 Beast Mode
- 21 Variables
- 487 Automate
- 104 Apps
- 379 APIs & Domo Developer
- 6 Workflows
- 22 Predict
- 6 Jupyter Workspaces
- 16 R & Python Tiles
- 319 Distribute
- 67 Domo Everywhere
- 252 Scheduled Reports
- 59 Manage
- 59 Governance & Security
- 1 Product Release Questions
- 5K Community Forums
- 37 Getting Started
- 23 Community Member Introductions
- 64 Community Announcements
- 4.8K Archive