Replace Value names

[MK9885]

Hello,

I'd like to replace the Names of few values in a field.

I've 10 Values that I'd like to rename and map it to my dim table.

Field1 coming from Dim1 Table, New Names to be replaced

Note: Field1 has many values but I just want to replace 5-6 values.

Field1    New Names

Value1     Value-1

Value2     Value-2

Value3     Value-3

Value4     Value-4

Value5     Value-5

Value5     Value-6

Value7     Value-7

I've tried mapping load but I believe I'm not doing it correctly...

@stalwar1‌

I can rename the fields but my main issue is to replace the old names with new names in my current dim table field.

Thanks.

[swuehl]

Mapping LOAD seems to be an appropriate approach:

Data Cleansing‌

Mapping … and not the geographical kind

If you have any issues, please post your current script code and some sample data, if possible.