Qlikview CASE statement or subquery inside a load and apply map

[matthewp]

ss

[petter]

You can use If() for that purpose.

[sasiparupudi1]

Try like this

t1:

load * Inline

[

PlaylistNo,Song ID,User

P36015,50434,JOHN

P39824,50434,LUKE

P41575,50434,MARK

P47775,50434,MATT 

P50028,50434,MATT 

];

Exemptsongs:

Load * Inline

[

Song ID

45875

65463

43785

90347

23456

89438

16745

50434

];

Exemptsongsmap:

Mapping LOAD

[Song ID],'Exempt' as [Song exempt]

Resident Exemptsongs;

ExemptUsermap:

mapping load * Inline

[

User,Exempt

MATT,1

];

NoConcatenate

final:

load PlaylistNo,[Song ID],if (ApplyMap('Exemptsongsmap',[Song ID],'NA')<>'NA' and ApplyMap('ExemptUsermap',User,'NA')=1,'Exempt','') as Exempt ,User resident t1;

DROP Table Exemptsongs,t1;

hth

Sasi

[sasiparupudi1 · Accepted solution]

load PlaylistNo,[Song ID],if (ApplyMap('Exemptsongsmap',[Song ID],'NA')<>'NA' and ApplyMap('ExemptUsermap',User,'NA')=1,'Exempt','Non-exempt') as Exempt ,User resident usermap;

load PlaylistNo,[Song ID],if (ApplyMap('Exemptsongsmap',[Song ID],'NA')<>'NA' and ApplyMap('ExemptUsermap',User,'NA')=1,'Exempt','Non-exempt') as Exempt ,User resident YourtableName;

[sasiparupudi1]

btw

did you include

ExemptUsermap:

mapping load * Inline

[

User,Exempt

MATT,1

];

?