Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all experts
Need advise on below
I have company names coming in and need output as below
ABC P Ltd - - Private limited
LMNOP LTD - - Public limited
i. e. When it is P separate from other words then Private Limited and if it is part of other word then Public Limited
I have applied mapstring but its working on only for first case and not other.
Kindly suggest
Is there a particular reason why you're using mappings and not a simple wildmatch?
Load
if(WildMatch(CompanyName,'* P *'),'Private Limited','Public Limited') as CompanyType
From ....