Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Mapping LOAD seems to be an appropriate approach:
Mapping … and not the geographical kind
If you have any issues, please post your current script code and some sample data, if possible.