Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

sriharsha96
Contributor II

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
Highlighted

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

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

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

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;

Community Browser