topic Re: Rename data within a table in QlikView

Rename data within a table

Thu, 09 Jun 2016 15:00:09 GMT

I have the following .qvd data loaded into my data model:

ADJ_NAME	CLM_STATUS	COV_CODE
BOB JONES	CL	GD
JAMES SMITH	CL	AD
SANDRA HARVY	CL	AB

In my data model script I am renaming,

ADJ_NAME as Name,

CLM_STATUS as Status,

COV_CODE as Injury

I would like to rename the data within the table-- CL to Closed, GD to General Liability, etc...

How is this possible?

Re: Rename data within a table

Gysbert_Wassenaar — Thu, 09 Jun 2016 15:44:33 GMT

Perhaps like this:

mapReplace:

MAPPING LOAD * INLINE [

Old, New

CL, Closed

GD, General Liabillity

etc....

];

MyData:

LOAD

ADJ_Name as Name,

ApplyMap('mapReplace',CLM_STATUS) as Status

ApplyMap('mapReplace',COV_CODE) as Injury

FROM

....source_qvd...

;

If a value CL occurs in both CLM_STATUS and COV_CODE, but should be replaced by different values then you need to use two mapping tables instead of only the one in the example code above.

Re: Rename data within a table

Aurelien_Martinez — Thu, 09 Jun 2016 15:46:18 GMT

Hi,

You can do :

[...]

Pick(Match(CLM_STATUS, 'CL', 'GD'), 'Closed', 'General Liabilit') as Status,

Pick(Match(COV_CODE, 'CL', 'GD'), 'Closed', 'General Liabilit') as Injury,

[...]

_MAP_

MAPPING LOAD * INLINE [

CODE, LABEL

CL, Closed

GD, General Liabilit

];

LOAD

ApplyMap('_MAP_', CLM_STATUS) as Status,

ApplyMap('_MAP_', COV_CODE) as Injury,

[...]

Re: Rename data within a table

shree909 — Thu, 09 Jun 2016 15:47:26 GMT

Hi,

You can do this by using applymap function

Create 2 mapping loads for status and injury

Status:

Mapping Load * Inline [

Status,Description

CL,Closed

];

COVCode:

Mapping Load * Inline [

COVCode,Description

GD,General Liability

AD ,ADDescription

AB,ABdescription

];

Table:

LOAD ADJ_NAME AS Name,

ApplyMap('Status',CLM_STATUS,'Unknown') AS Status,

ApplyMap('COVCode',COV_CODE,'Unknown') AS Injury

FROM

[https://community.qlik.com/thread/220240]

(html, codepage is 1252, embedded labels, table is @1);

Re: Rename data within a table

Thu, 09 Jun 2016 16:08:38 GMT

Hi,

I have not used Pick(Match( before. What is the difference int he Apply Map and the Pick Match?

Re: Rename data within a table

Aurelien_Martinez — Thu, 09 Jun 2016 16:27:14 GMT

Pick(Match(Field, 'Val1', 'Val2'), 'Value1', 'Value2'))

is like a

If(Field = 'Val1', 'Value1', If(Field = 'Val2', Value2))

In your case the mapping load/ applymap is better (performance and maintenance)