rename field values

[Anonymous]

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]

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 · Accepted solution]

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]

Tnx Krishna & Ramon