topic Re: Problem changing field values in QlikView

Problem changing field values

Wed, 12 Aug 2015 07:16:36 GMT

Hi,

I have a problem trying to change field values in a file from codes to descriptions. I have used the 'if' statement in the script below - I'd appreciate if someone could help show me what to do.

Thanks, Simon

LOAD

IF (CARE_TYPE = '4', 'Acute'),

HEORG_ID,

MRN,

EPISODE_NO as Episode,

CARE_TYPE,

IMPAIRMENT

FROM

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Re: Problem changing field values

Anonymous — Wed, 12 Aug 2015 08:17:57 GMT

if you only want to Substitute ID through Description I would prefer applymap (see last sentence as base for applymap)!

If use If:

LOAD

IF (CARE_TYPE = '4', 'Acute') as CARE_TYPE_DESC,

HEORG_ID,

MRN,

EPISODE_NO as Episode,

CARE_TYPE,

IMPAIRMENT

FROM

If you have more than 1 CARE_TYPE ID I would use an Inline table (if you donot have a source with ID and Description, if you have, take that source!)

Re: Problem changing field values

settu_periasamy — Wed, 12 Aug 2015 08:20:48 GMT

I think you should give alias name for that field.

IF (CARE_TYPE = '4', 'Acute') as Care_Type_New,

Re: Problem changing field values

Thu, 13 Aug 2015 00:36:48 GMT

Thank you!

Re: Problem changing field values

Thu, 13 Aug 2015 00:37:07 GMT

Thanks!

Re: Problem changing field values

Thu, 13 Aug 2015 00:37:33 GMT

Thanks!