You can create an XL file or Inline load in script..
If you do not have hundreds of companies then below steps should work ...
Load * Inline [
Company Abbreviation XYZ Supply Co Atlanta, XYZ Supply Co XYZ Supply Co Lawrenceville, XYZ Supply Co XYZ Supply Co Hartford, XYZ Supply Co XYZ Supply Co Philadelphia, XYZ Supply Co ABC Distribution Co Atlanta, ABC Distribution Co ABC Distribution Co Lawrenceville, ABC Distribution Co ABC Distribution Co Hartford, ABC Distribution Co ABC Distribution Co Philadelphia, ABC Distribution Co
Use Abbreviation in front end for filters as new field and company field for your aggregation?
You can use the wildmatch function:
Example the field name would be Company and you have this data
XYZ Supply Co Atlanta
XYZ Supply Co Lawrenceville
XYZ Supply Co Hartford
XYZ Supply Co Philadelphia
ABC Distribution Co Atlanta
ABC Distribution Co Lawrenceville
ABC Distribution Co Hartford
ABC Distribution Co Philadelphia
So in the Load of your table you have to create one field that has the wildmatch function like this:
if(WildMatch(Company,'XYZ Supply Co*')=1,'XYZ Supply Co',
if(WildMatch(Company,'ABC Distribution Co*')=1,'ABC Distribution Co','Others') )
You can Attach more conditions so you dont need to aggregated manually in a inline or xl file