Merging Single Filed values into One

[jyoshna]

HI Team,

I have a field called Commodity Group which has data as below, I want Natural Gas and Nat Gas ICE to be represented as Natural Gas under Commodity_Type. How to achieve this.

Commodity_ Type

Natural Gas

Agriculture

Base Metals

Crude oil

Refined Product

Nat Gas ICE

Pre Metal

[zar · Accepted solution]

Hi!

Yo can use Mapping to achieve the change (if you are using load script):

Map_Correction_Gas:

Mapping

Load * Inline [

MapFrom, MapTo

Nat Gas ICE, Natural Gas

]

;

DATA:

Load 

[Commodity_Type]

    ,ApplyMap('Map_Correction_Gas',[Commodity_Type],[Commodity_Type]) as [Corrected_Commodity_Type]

;

Load * Inline [

Commodity_Type

Natural Gas

Agriculture

Base Metals

Crude oil

Refined Product 

Nat Gas ICE

Pre Metal

]

;

Or, if you are using Data Manager, you can simply replace values:

[jyoshna]

@zarzar

ThankYou for providing the solution.