topic Re: like condition in QlikView

like condition

raadwiptec — Mon, 14 Dec 2015 14:02:01 GMT

Hi All

My data look as below

prodcodename

10CAPACITOR

20ASSEMBLY

35WIRES

44SWITCHES

I want to have something like this to adda new column .in the script .if prodcodename has 10 then CA

if prodcodename has 20 then ASM

if prodcodename has 35 then WI

I tried few like conditions match etc..but null values are coming

Re: like condition

MK_QSL — Mon, 14 Dec 2015 14:04:29 GMT

Load

prodcodename,

Pick(WildMatch(prodcodename,'*10*','*20*','*35*'),'CA','ASM','WI') as Flag

Inline

[

prodcodename

10CAPACITOR

20ASSEMBLY

35WIRES

44SWITCHES

];

Re: like condition

puttemans — Mon, 14 Dec 2015 14:35:24 GMT

Hi there,

Is it always the first 2 digits? If so, then you can try something like this :

Map_type

MAPPING LOAD * inline

[10, CA

20, ASM

35, WI]

Load

Applymap('Map_type', left(yourvariable, 2), '-') as Flag

FROM ....

(a sample file would help)

Regards,

Johan

Re: like condition

Mon, 14 Dec 2015 14:46:00 GMT

Hi raad, try this:

TEST:

LOAD

if ( isNull(prodcodename)=-1 , '00' , // I put '00' but you can put the value that you want or just '' or null()

if( wildmatch(prodcodename , '*10*')=1 , 'CA' ,

if( wildmatch(prodcodename , '*20*')=1 , 'ASM' ,

if ( wildmatch(prodcodename , '*35*')=1 , 'WI' ,

if ( wildmatch(prodcodename , '*44*')=1 , 'SW' , ) ) ) ) ) as FLAG;

I hope that it help you !

Regards

Agustin