Pick Wildmach null value

[realpixel]

Hello,

I use the following expression

Pick(WildMatch([HMUSER2],'0','1','2','6'),'VIDES','ZU','ZP','ZL') as ZONE1 but I have some field that are blank.

I want to remplace blank value by 'VIDES', I try to use the value '0' or 'NULL' without succes.

Sommeon have an idea?

[arbernardez_old]

hi,

if you have something like this:

LOAD * INLINE [

    HMUSER2, ZONE

      1, ZU

      2, ZP

      6, ZL

    <Null>,VIDES

    "",VIDES

    *,VIDES

    ,VIDES

    NULL,VIDES

];

and then you apply the pick like this

Pick(WildMatch([HMUSER2],'1','2','6')+1,'VIDES','ZU','ZP','ZL') as ZONE1

result will be

HMUSER2	ZONE	ZONE1
*	VIDES	VIDES
	VIDES	VIDES
<Null>	VIDES	VIDES
NULL	VIDES	VIDES
1	ZU	ZU
2	ZP	ZP
6	ZL	ZL

regards

[realpixel]

Thank you Alberto,

Sorry I had not seen have your latest solution in your previous post

The solution under works fine

Pick(WildMatch([HMUSER2],'1','2','6')+1,'VIDES','ZU','ZP','ZL') as ZONE,