topic Re: Apply Map Concept in QlikView

Apply Map Concept

Fri, 01 Nov 2013 07:57:44 GMT

Hi Force,

I have two table

1. One with Student Id,Student Name

2. Second table with Student Name, Tamil, English, Maths, Science,Social.

Table 1:

Student ID , Student Name

1 , Sachin

2 , Sarathy

3, David

Table 2:

Mapping

Student Name , Tamil , English, Maths, Science , Social

Sachin , 85 , 90,100,95,70

Sarathy ,70,72,83,45,90

David , 80 ,95,90,95,90

I want the result of

Student id , Student Name , Tamil, English,Science, Social

1 , Sachin,85,90,100,95,70

2,Sarathy,70,72,83,45,90

3, David , 80,95,90,95,90 using Apply map

i tried with Apply map but it shows Mapping requires 2-Column input. Please give the solution ASAP.

Regards,

Sakthivel.S

Re: Apply Map Concept

Anonymous — Fri, 01 Nov 2013 08:26:51 GMT

Sakthivel

Does this help you ?

StudentMap:

Mapping Load

[Student ID]

[Student Name]

from Table1;

Table3:

Load

ApplyMap('StudentMap',[Student Name] ) as [Student ID] ,

[Student Name] ,

Tamil ,

English,

Maths,

Science ,

Social

from Table2;

Best Regards, Bill

Re: Apply Map Concept

Fri, 01 Nov 2013 09:04:18 GMT

Hi Bill,

Thank u very much. its working fine. and thats what i want too.