Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlikers,
I'm loading a Table and based on the informations I have in the field 'comment' I would like to build a new field Status.
LOAD
comment,
if(comment like '*Test*', 'Test',
if(comment like '*Blocked*', 'Blocked',
if(comment NOT LIKE '*check*' and NOT LIKE '*analyse*', 'To be checked',
if(comment like ......)))) AS Status
From ...
Thanks for your help
Not Wildmatch(comment, '*check*','*analyse*')
Not Wildmatch(comment, '*check*','*analyse*')
Hi,
Use the wildmatch function.
if(Wildmatch(comment,'*Test*'), 'Test',
if(Wildmatch(comment,'*Blocked*'), 'Blocked',
...............
Regards,
Kaushik Solanki
And if you insist on using LIKE, you can try this:
if(not comment LIKE '*check*' and not comment LIKE '*analyse*', 'To be checked',
It worked perfectly! thanks for your help
Thanks for this solution