topic Re: Apply Map Function in QlikView

Apply Map Function

rahulsingh12 — Mon, 03 Jul 2017 05:10:49 GMT

Hi,

I have some issues with apply map.

The scenario is:

I have 2 tables A and B

A has 2 columns ID1,ID2

B has 3 column ID3,ID4,ID5

The column ID2 contains values from ID3. Hence ID3 column is Master ID..

Thus while loading table B I want to add a flag if ID3 column in ID2 then mark the flag as 1 else 0.

How can I achieve this with applymap.

Regards,

Re: Apply Map Function

prma7799 — Mon, 03 Jul 2017 05:16:17 GMT

Like this??

Mapping LOAD

ID1,ID2 as ID3 ;

LOAD

ID3,

ID4,

ID5,

If(ApplyMap('A', ID3 , Null()) ,1 , 0) as Flag

;

Or please share some sample app with some data.

Re: Apply Map Function

passionate — Mon, 03 Jul 2017 05:21:43 GMT

Hi,

Use some thing like:

LOAD ID1,

if(ApplyMap('Abc',ID2,'0')=0,0,1),

ID3

FROM

(ooxml, embedded labels, table is Master);

Regards,

Pankaj

Re: Apply Map Function

prma7799 — Mon, 03 Jul 2017 05:23:53 GMT

Or Please try like this...

Re: Apply Map Function

vikasmahajan — Mon, 03 Jul 2017 05:47:34 GMT

Please find solution

Vikas

Re: Apply Map Function

vinieme12 — Mon, 03 Jul 2017 06:17:39 GMT

prma7799 There is no need to Alias the mapping field, but it must be the first column in the mapping table

Mapping LOAD

ID2,ID1

;

LOAD

ID3,

ID4,

ID5,

If(ApplyMap('A', ID3 , Null()) ,1 , 0) as Flag

Re: Apply Map Function

vinieme12 — Mon, 03 Jul 2017 06:20:28 GMT

Read more about Applymap() on the community

ApplyMap ‒ QlikView

Don't join - use Applymap instead

Using ApplyMap() Function with Mapping Load in QlikView - QlikView Blog, QlikView Videos and Tips at QlikShare

https://www.quickintelligence.co.uk/applymap-is-it-so-wrong/

Re: Apply Map Function

prma7799 — Mon, 03 Jul 2017 06:25:00 GMT

vinieme12‌ ,

Thanks Vineeth.

Re: Apply Map Function

ysj — Fri, 19 Jan 2018 10:43:39 GMT

Initial:

Mapping

LOAD

ID2,

ID1

INLINE [

ID2, ID1

1, Rock

2, Brock

3, TripleH

4, StoneCold

];

MasterLaod:

LOAD

ID3,

ID4,

ID5

,ApplyMap('Initial',ID3,'Unkonwn'),

If(ApplyMap('Initial',ID3),0,1) as Flag

INLINE [

ID3, ID4, ID5

1, Rock, "People's Champ"

2, Brock, USA champ

3, TripleH, TagTeam

4, StoneCold, Universal WWE

5, Kane, Raw Champ

6, UnderTaker, Smackdown Champ

7, BigShow, Intercontenential

];

Re: Apply Map Function

ysj — Fri, 19 Jan 2018 10:44:47 GMT