Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
I would strongly suggest that you do this in the script, e.g. using a MAPPING approach:
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?
Then in calculated dimensions use this script:
=subfield(Customer, ' ', 1)