How to prevent duplicated company name appear ?

[paulyeo11]

Hi All

I have a Table , it display duplicated company name.

The issue is cause by my AR Table i using COMPANY_PAY and my sales order table i use COMPANY field name.

So the system pick up both name.

May i know can i remove duplicated company name ?

Paul

[paulyeo11]

my QVW

[sunny_talwar · Accepted solution]

May be you need to cleanse your data using ApplyMap

Data Cleansing