Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Colleagues, good evening!
Has anyone faced with tasks to use wildmatch function in dynamic update?
I have very simple data set:
ID | Name | Result |
1 | Name | |
2 | 1Name1 | |
3 | Name1 | |
4 | Nam | |
5 | N |
So in DU i need to set "Done" value in Result field for those records, which met the following condition:
WildMatch(Result, '*Name*').
I read some threads about this topic (like using LIKE statement from SQL), but it doesn't give necessary result.
Could anyone advice something?
p.s. Using If statement isn't appropriate solution for my task.
Andrew.
Thanks!
I tried your statement, but it doesn't give any result (nothing happens)
Hi Andrei,
Have a look at the attached file. Have a nice week ahead!
=Concat({<Name = {"*Name*"}>} 'Update Main SET Result =' & chr(39) & 'Done' & chr(39) & ' Where Name =' & chr(39) & Name & chr(39) , ';' & chr(13))