How to get pick value for matching multiple values at a time by using pick and wildmatch function

[Gopi_E]

Hi All,

I have two fields  like

TranType	Description
Tran	Delivery
Tran	Post
Tran	Pending
Tran	Delivery
Tran	Service
Tran	Statement
Tran	Service Charge
Tran	_Hiding
Tran	Block'
Tran	Deposit
Tran	Monthly Deposit

By using the above data I will create another field like Category and I want result like

TranType	Description	Category
Tran	Delivery	Delivery
Tran	Post	Post
Tran	Pending	Post
Tran	Delivery	Delivery
Tran	Service	UnderService
Tran	Statement	Lift Charge
Tran	Service Charge	Lift Charge
Tran	_Hiding	Hide
Tran	Block'	Statement Block
Tran	Deposit	Deposit
Tran	Monthly Deposit	Deposit
Tran	Others

Here I have used a pick and WildMatch function and its working

But the problem is I have 6lacks records with  30 Descriptions and Some Description coming into the same category,

My expression is:

=pick(WildMatch(Description,'Delivery','Post','Pending','Service','Statement','*Service Charge','*_Hiding','Block','Deposit','Monthly Deposit','* *'),'Delivery',Post','Post','UnderService','Lift Charge','Lift Charge','Hide','Statement Block','Deposit','Deposit')

This is working, but the problem is here I should repeat all repeated Same Category in pick values for matching different Description.

please suggest a way how to match multiple Descriptions with one pick value

Thanks in Advance

Regards,

Gopi

[trdandamudi]

Use ApplyMap() method to resolve this.

[Gopi_E]

Hi thirumala,

thanks for the reply,

but here the problem is there is no Category field, Category is an expression result.

[trdandamudi]

Do you want this on the script side or on the front end ?

[Anonymous]

hi,

Kindly do mapping load for Description and categoy,

and

load the table Trantype, Description and

use the applymap for getting category

thanks

[Gopi_E]

I Thirumala,

I was tried using apply map but it didn't give exactly what I want, that's why I am going front side.

if you know any way please suggest me, if its back script or front side no problem.

[trdandamudi]

Please go thru the attachment:

[Gopi_E]

Hi Yogaraj,

Thanks for the reply

Here I put the example data, original data Description is coming with different strings with different symbols. that's why I should write WildMatch.So if any word matching in Description it's coming with one category,

and the client gives only Category names what we pick that matching words in Description. They didn't give Category Field.

Here if Description coming with  *Lift Charge*  we should display that category is Charges, like that I want.