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: 
pascaldijkshoor
Creator
Creator

Replacing field values in the data manager

Hello,

I want to replace field values of dimensions in the data manager. For example I have the following field values: USA, US and United States, while i want them all to be named USA. This should be possible in the replace tab. However this is only possible when a table has 100 or less distinct values, while my table has 2800 distinct values.

Is there a way to solve this?

Regards,

Pascal

1 Reply
vamsee
Specialist
Specialist

Hello Pascal,

I would use a mapping loads to do this.

Please find the attached, hope it meets you requirement.

Thanks

Vamsee

Note:    Instead of the inline table you can use an excel if the data set is huge