replace value

[rohit_bibe07]

How to replace column older values to new values ?

old value                    new value

Data science               Data Science

JAVA                               Java

sap                                  SAP

and so on...

[vchuprina · Accepted solution]

Hi,

You can create a mapping table and then use applymap function.

As example 

Name_Map:

Mapping

LOAD * Inline [

KEY, VALUE

Data science ,             Data Science

JAVA,                               Java

sap,                                  SAP

];

Your load:

Data:

LOAD

 applymap('Name_Map', Name) AS Name,

...

From ...

Regards,

Vitalii

[vinieme12]

either mapping load as show below or just left join; and drop the old column

RawData:

Load * from sSomeQvd;

Left Join(RawData);

old value                    new value

Data science               Data Science

JAVA                               Java

sap                                  SAP

drop field oldvalue;

rename field newvalue to oldvalue;