topic Re: wildmatch in QlikView

wildmatch

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

Hi all,

I have field like

custname

berryNp

jhonNp

savinNP

cashRp

jasnRp

thsnKp

msnKp

-----------------------------------here every month customers will add this month 10 are there next month it will be 15

so I need separate field ending with all Np,Kp,Rp separate

how to achieve this?

Re: wildmatch

chinnuchinni — Fri, 23 Mar 2018 06:14:37 GMT

try this:

load *,if(right(upper(custname),2)='NP',custname) as NP_custname ,if( right(upper(custname),2)='KP',custname) as KP_custname ,if( right(upper(custname),2)='RP',custname) as RP_custname Inline [

custname

berryNp

jhonNp

savinNP

cashRp

jasnRp

thsnKp

msnKp

];

EXIT SCRIPT ;

Re: wildmatch

sasiparupudi1 — Fri, 23 Mar 2018 13:38:35 GMT

Load

custname,

If(SubStringCount(custname,'Np'),SubField(custname,'Np',1),If(SubStringCount(custname,'Rp'),SubField(custname,'Rp',1),If(SubStringCount(custname,'Kp'),SubField(custname,'Kp',1)))) As CustName1,

If(SubStringCount(custname,'Np'),'Np',If(SubStringCount(custname,'Rp'),'Rp',If(SubStringCount(custname,'Kp'),'Kp'))) As Suffix

Inline

[

custname

berryNp

jhonNp

savinNP

cashRp

jasnRp

thsnKp

msnKp

];

Re: wildmatch

ychaitanya — Fri, 23 Mar 2018 13:43:36 GMT

OR simply like this.

LOAD

UPPER(RIGHT(FIELD,2)) as RP_custname,

RP_NAME

FROM TABLE:

so that association also holds

Regards