Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone, is it possible to write something like a mask in case or some other way?
case when id_code in (
'8.2.28.',
'7.2.28.',
'24.2.28'
)
then 'documentation_expertise'
Trying this method or with like, but something is not right)
case when id_code in (
'*.2.28.')
then 'documentation_expertise'
Try
If(Match(id_code,'8.2.28.','7.2.28.','24.2.28'), 'documentation_expertise')
The point is that I only know what the code ends in, that is, there will be a lot of codes where only the end will match, for example '.2.28'
Try
If(WildMatch(id_code,'*.2.28'), 'documentation_expertise')
Can I use it on the case principle? Because I have a couple more such lines with other codes and at the end
Else 'No activity' end
You can try like:
Pick(WildMatch(id_code, '*.2.28', '*.2.27', '*.2.29')+1, 'No Activity', 'case1', 'case2', 'case3')