You could make an excel sheet with all the vendors you wish to exclude.
In the excel have a column with the vendor number (or if that’s not available vendor name), another that says the country for which it should be excluded (the name should match the way it’s written in “Cases”.“LocalMarket”) and another column called something like “excluded” where every row in the table has the value ‘yes’.
The next step is to integrate this into your data model. (Please not this explanation is your Celonis 4 customers, for any IBC customers reading this, excel sheets are uploaded by opening the relevant “data pool” in the “Event collector” and going to “File Uploads” and uploading the file there.)
For a Celonis 4 customer like you, go to the Celonis start page, click on the relevant project, then on “data models” and select the data model used in the relevant analysis.
Then in the data model, click on the “tables” tab, then on “Import data”, finally select “Import from file” from the drop down.
In the next window add your file.
The next step is to connect this table to the vendors table of your database. Do this by going to the keys tab and clicking add foreign key. Then for table1 select the excel you just uploaded and for table2 your Vendor table. Then select then from both tables select the Vendor number.
Then when you open your analysis, all tables will be loaded including your excel. So, you can now add a filter
FILTER NOT(“table”.”country” = “South Africa” AND “excel table”.”exclude” = ‘yes’);
I haven’t been able to fully test this solution so if it doesn’t work please let me know.