Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

Mapping Data:

NameAmount
Harsha10
Pavan20
Jaya30
Sarathi40
Shashi50

Source Data:

Output Name
Sri Harsha
Pavan Kishore
PJayaram
Muruga Sarathi
Sahshiprasad

Output Table:

Output NameOutput Amount
Sri Harsha10
Pavan Kishore20
Jayaram30
Muruga Sarathi40
Sahshiprasad50
2 Replies
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
Not applicable
Author

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;