Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
MK9885
Master II
Master II

Replace Value names

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.

1 Reply
swuehl
MVP
MVP

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.