Group into one

[soha1902]

Hi All,

I have below field

Customer

ABC Corp

ABC Limited

XYZ

DEF

HJK ASSOCIATES

HJK Finance

My Requirement is if 2 Customer names having the similar left name then I need to combine them into one name.

For example in above fields we have ABC CORP and ABC LIMITED so here ABC is common for both so I need to combine as ABC, likewise HJK ASSOCIATES and HJK Finance as HJK.

I want to implement this in UI level not in script level plz suggest.

[swuehl]

I would strongly suggest that you do this in the script, e.g. using a MAPPING approach:

Data Cleansing

You can also use Wildmatch() function to create your groups in calculated dimensions, but why don't you want to do this once in the script?

[MindaugasBacius]

Then in calculated dimensions use this script:

=subfield(Customer, ' ', 1)