Replace Value names

MK9885 — Wed, 25 Nov 2020 16:16:04 GMT

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...

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.

Re: Replace Value names

swuehl — Wed, 23 Nov 2016 19:45:03 GMT

Mapping LOAD seems to be an appropriate approach:

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