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 -
It works. It does my need. It is a powerful function. I used it for join
0
Categories
- All Categories
- 1.5K Product Ideas
- 1.5K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 279 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.7K Transform
- 89 SQL DataFlows
- 562 Datasets
- 2K Magic ETL
- 3.4K Visualize
- 2.3K Charting
- 584 Beast Mode
- 13 App Studio
- 28 Variables
- 585 Automate
- 142 Apps
- 415 APIs & Domo Developer
- 27 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 360 Distribute
- 98 Domo Everywhere
- 260 Scheduled Reports
- 2 Software Integrations
- 94 Manage
- 91 Governance & Security
- 9 Product Release Questions
- Community Forums
- 37 Getting Started
- 28 Community Member Introductions
- 89 Community Announcements
- 4.8K Archive