Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I have 2 tables one is static data and other date with details.Both are connected with common field. when i try to pull resident i get null value in resident which i want to name it as other.Qvd file attached. appreciate help
hi,
Use Applymap function with Mapping load,
TAB1:
Mapping Load
Student,
Resident
from:
Tab2:
Load
Student,
Applymap('Tab1',Student,'Others') as Resident,
mark1,
Mark2
From
ksrini
hi,
Use Applymap function with Mapping load,
TAB1:
Mapping Load
Student,
Resident
from:
Tab2:
Load
Student,
Applymap('Tab1',Student,'Others') as Resident,
mark1,
Mark2
From
ksrini
Thanks yes this is working.