topic Re: Applymaping in QlikView

Applymaping

Anonymous — Thu, 26 Nov 2015 12:46:03 GMT

Hi,

I am having one table contains Claim ID, Claim Type, PreandPost, and Main Claim ID in one table, I need to mapp PreandPost claims Claim Type as Main Claim ID Claim Type.

Data
claimid	Original ClaimType	PreandPost	mainclaimid	Need the Out put as
838526	MR	PreAndPost	-	PP
838534	MR	-	-	MR
838536	MR	-	-	MR
838537	MR	PreAndPost	843848	PP
838541	MR	-	-	MR
843848	PP	-	-	PP
839111	MR	-	-	MR
839119	MR	PreAndPost	844425	PP
839232	MR	-	-	MR
839240	MR	-	-	MR
844425	PP	-	-	PP

Re: Applymaping

swuehl — Thu, 26 Nov 2015 12:57:58 GMT

LOAD

claimid,

OriginalClaimType,

PreandPost,

mainclaimid,

if( PreandPost = 'PreAndPost', 'PP', OriginalClaimType) as NewOutput

FROM ...;

Re: Applymaping

Mark_Little — Thu, 26 Nov 2015 13:16:05 GMT

Hi,

I would approach it the same way as swuehl.

Mark

Re: Applymaping

puttemans — Thu, 26 Nov 2015 13:35:10 GMT

Hi Rafee,

If you'd need to map this info into another table, then it would look like:

Map_claim:

MAPPING LOAD

claimid,

if( PreandPost = 'PreAndPost', 'PP', OriginalClaimType) as ...

FROM/RESIDENT .....

LOAD

Applymap('Map_claim', claimid) as .....

FROM....

Kind regards,

Johan