topic Re: How to get pick value for matching multiple values at a time by using pick and wildmatch function in QlikView

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

Gopi_E — Wed, 25 Nov 2020 16:16:04 GMT

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

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

trdandamudi — Tue, 11 Sep 2018 15:24:49 GMT

Use ApplyMap() method to resolve this.

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

Gopi_E — Tue, 11 Sep 2018 15:30:58 GMT

Hi thirumala,

thanks for the reply,

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

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

trdandamudi — Tue, 11 Sep 2018 15:33:02 GMT

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

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

Anonymous — Tue, 11 Sep 2018 15:40:25 GMT

hi,

Kindly do mapping load for Description and categoy,

and

load the table Trantype, Description and

use the applymap for getting category

thanks

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

Gopi_E — Tue, 11 Sep 2018 15:41:24 GMT

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.

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

trdandamudi — Tue, 11 Sep 2018 16:08:21 GMT

Please go thru the attachment:

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

Gopi_E — Tue, 11 Sep 2018 16:21:35 GMT

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.