topic ApplyMapping using values in two fields? in QlikView

ApplyMapping using values in two fields?

Sat, 21 Jul 2012 22:13:00 GMT

How can I use values from two fields in the mapping, (that is if the value from a field meets a certain criteria then it should pick the value from another field)

In the SQL statement it would look like this:

CASE when WWHS = "IT' then LLOC ELSE WWHS END

(where WWHS was the warehouse field and if the warehouse was 'IT" then it would be substituted with a value in the Location field)

Re: ApplyMapping using values in two fields?

nagaiank — Sat, 21 Jul 2012 22:24:21 GMT

You may use the following script:

If(WWHS = "IT', LLOC, WWHS) as newWWHS

Re: ApplyMapping using values in two fields?

Sat, 21 Jul 2012 22:32:25 GMT

Hi Krishnamoorthy:

Thanks for your reply, what would happen in cases there are like 10 or more values to be used (like in my example instead of just IT if I need to use CT, RT, LT,XT and s on) the if statements become too much nested and was looking for a more neater way

Re: ApplyMapping using values in two fields?

Sat, 21 Jul 2012 22:32:36 GMT

Hi Krishnamoorthy:

Re: ApplyMapping using values in two fields?

nagaiank — Sat, 21 Jul 2012 23:30:15 GMT

Use

If(Match(WWHS,'IT','CT','RT','LT','XT')=1, LLOC, WWHS) as newWWHS

Re: ApplyMapping using values in two fields?

Sun, 22 Jul 2012 00:03:17 GMT

HI Krishnamoorthy:

Thanks for your responce, I used the formulae as

if(match(WWHS,'IT','CT','RT','LT','XT')<>0,LLOC,WWHS) and it worked

thanks

Re: ApplyMapping using values in two fields?

Sun, 22 Jul 2012 00:03:24 GMT

HI Krishnamoorthy:

Thanks for your responce, I used the formulae as

if(match(WWHS,'IT','CT','RT','LT','XT')<>0,LLOC,WWHS) and it worked

thanks