topic Re: rename field values in QlikView

rename field values

Anonymous — Wed, 29 Jul 2015 15:10:44 GMT

how to rename field values while loading or after loading the table, which these values are shared between two other filed values.

Whenever I click Peter then i should see only shift 1, the shift 2 should be renamed to shift1 and the end result should be (i.e count should be 2)

please find attached file and sample data.

john

ramoncova06 — Wed, 29 Jul 2015 16:09:43 GMT

how do you define which user gets what value ?

once you define that, you could use a mapping to assigning the values

mapping

shiftmapping:

LOAD Person,

Type,

FROM

(ooxml, embedded labels, table is Sheet1);

LOAD Person,

applymap('shiftmapping',Type) as Type,

Hrs

FROM

(ooxml, embedded labels, table is Sheet1);

Qrishna — Wed, 29 Jul 2015 16:30:48 GMT

By using match function u can get your desired output.

LOAD Person,

if(match(Person,'Peter'),'Shift1',Type) as Type,

Hrs

FROM

(ooxml, embedded labels, table is Sheet1);

Anonymous — Wed, 29 Jul 2015 16:44:14 GMT

Tnx Krishna & Ramon