topic Re: Mapping in QlikView

Mapping

Mon, 15 Feb 2016 08:57:10 GMT

Hello All,

I need to map all those starting by Status_description AP001 to the status code AP001.

Example:

Status_Description Status_Code

AP001 THUR AP001

AP001 ERTD AP001

AP001 PLYT AP001

So I created a Mapping as below:

Map:

Mapping load * inline [

Status_Description,Status_Code

AP001* , AP001

But it does not work.

Any idea?

KR,

Hasvine

Mark_Little — Mon, 15 Feb 2016 09:02:44 GMT

Hi,

I think it will be down to the '*', not sure it is works with the wildcard in a mapping.

What is it your trying to do?

Have you thought about mapping usign the subfield() function.

SUBFIELD(Status_description,' ',1) as Status_Code

Mark

tresB — Mon, 15 Feb 2016 09:03:05 GMT

Mapping doesn't work with wildcards. Try with WildMatch(), like:

Load

if(WildMatch(Field, 'AP0001*') , 'AP0001' , Field) as NewField

tresB — Mon, 15 Feb 2016 09:06:45 GMT

Or, even try with MapSubstring(). You may refer: Re: Wildcard when ApplyMap

Anonymous — Mon, 15 Feb 2016 09:42:07 GMT

Like useful compare the fields

Anonymous — Mon, 15 Feb 2016 09:58:07 GMT

Try somthing like?

Where/IF Status_Description like 'AP001*'

sathishkumar_go — Mon, 15 Feb 2016 12:32:24 GMT

Try this,

if(left(Status_Description,5) = 'AP001','AP001') AS status_code

-Sathish