Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Test
Dhanunjay,Can you provide sample data??
=if(wildmatch(lower([Error Text]),'*you can''t use business partner*'),'Invalid Business Partner',
if(wildmatch(lower([Error Text]),'*owner is inactive*'),'Owner is Inactive',
if(wildmatch(lower([Error Text]),'*exception:*'),'Exception in c4c',
if(wildmatch(lower([Error Text]),'*please enter an existing product id*'),'Missing Technology')))) as Category
Edit: syntax error is corrected
Try this
if(WildMatch(Lower([Error Text]),'*business partner*'),'Invalid Business Partner',
if(WildMatch(Lower([Error Text]),'*Owner is Inactive*'),'Owner is Inactive',
if(WildMatch(lower([Error Text]),'*Exception:*'),'Exception in c4c',
if(WildMatch(Lower([Error Text]),'*Please enter an existing product ID*'),'Missing technology'))))
Jakhas