Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Apply Map Concept

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

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

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

View solution in original post

2 Replies
Anonymous
Not applicable
Author

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

Not applicable
Author

Hi Bill,

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