Excludeing Unwanted Country in the Script level

[manishapanda1]

Hi Friends ,

I have a scenario where my Country source table is a  Excel file .in the Country column I have 100 country but user don't want few countries (eg: Aus,Uk,Us…...etc) approx 20 country shouldn't be there in the Dashboard.

can some one please help me to achieve this.

Thanks,

Manisha Panda

[paulselousyoriz · Accepted solution]

If the countries to be excluded may change quite often , it might be a good option to include these countries in a seperate Excel file. So that when this list changes, you do not have to amend the script but just amend this Excel file. Here is an example code below:

"CountriesToExclude:
Load
Country As Country_To_Exclude
FROM [lib://Community\Countries_To_Exclude.xlsx]
(ooxml, embedded labels, table is Blad1);

Countries:
Load
Country
FROM [lib://Community\CountryList.xlsx]
(ooxml, embedded labels, table is Blad1)
Where Not Exists(Country_To_Exclude,Country);

Drop table CountriesToExclude;"

Good luck,

Paul

[manishapanda1]

Thanks Paul it's fulfilled my Requirement.

Thanks 🙂