How to normalize the data

[RajeshR]

I have a table with columns
Product Name, Product description, Product Type, Vendor

Product Name and Vendor columns have normalized data,
Product description and Product Type are with different values. With this data, I do not get exact count when grouped by Product description.

Either I can group by product name for measures and show top 1 proper product description for dimensions in set analysis.
Or  I can add one more field / rename the other product description (like below)  in data manager 

Kindly Note : I can take any of the matching product description and product type or with vendor value.

Could someone please help ?

Thanks in Advance

[Patricia_Silva]

Hello @RajeshR, maybe you could normalize it in the script where any dimension containing "Apple" should be named as Apples. / Apples / Apple etc, have you tried so?

[marcus_sommer]

By just a few cases you may query and correcting the spelling directly within the load with the various available string-functions within more or less nested if-loops. But in most scenarios it's much easier to harmonize the values with a Mapping ‒ QlikView,

- Marcus