Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Use ApplyMap() method to resolve this.
Hi thirumala,
thanks for the reply,
but here the problem is there is no Category field, Category is an expression result.
Do you want this on the script side or on the front end ?
hi,
Kindly do mapping load for Description and categoy,
and
load the table Trantype, Description and
use the applymap for getting category
thanks
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.
Please go thru the attachment:
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.