Need desired output using "Source Data" and "Maping Data" tables...

[Anonymous]

Mapping Data:

Name	Amount
Harsha	10
Pavan	20
Jaya	30
Sarathi	40
Shashi	50

Source Data:

Output Name
Sri Harsha
Pavan Kishore
PJayaram
Muruga Sarathi
Sahshiprasad

Output Table:

Output Name	Output Amount
Sri Harsha	10
Pavan Kishore	20
Jayaram	30
Muruga Sarathi	40
Sahshiprasad	50

[Gysbert_Wassenaar]

The QV Cookbook has an example of wildcard mapping. See this discussion: http://community.qlik.com/message/188895#188895

[#3]

hi,

Use the following script

Mapping1:

LOAD Name,Amount INLINE [
Name,Amount
Harsha,10
Jaya,30
Pavan,20
Sarathi,40
Shashi,50
];
JOIN
LOAD * INLINE [
SourceData
Sri Harsha
Pavan Kishore
PJayaram
Muruga Sarathi
Shashiprasad
];


NoConcatenate
c:
Load
*
Resident Mapping1
WHERE WildMatch(SourceData, '*' & Name & '*');

DROP TABLE Mapping1;