Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Hi Bill,
Thank u very much. its working fine. and thats what i want too.