Where exists/match/wildmatch????

[bobbydave]

I have a table.

I only want to load 4 countries coz the required data is only in these 4 countries.

Countries:

Code as %Country,

Code,

Country as CountryName

Country

from

Country.xlsx

where match (Code, 'GR', 'TR', UK', FR')

but it still loads all countries.

Any ideas? I know it has to be my Where clause

[kumarkp412]

Hi David ,

The above where match condition   should give result as expected.

Can you please provide the sample script.

Thanks

Kumar KVP

[Anil_Babu_Samineni · Accepted solution]

Countries:

Code as %Country,

Code,

Country as CountryName

Country

from

Country.xlsx

where wildmatch(Country, 'GR', 'TR', UK', FR')

Can you please post sample.

If you want this in Charts please use Set Alalysis

Like

Sum({<Country = {'GR', 'TR', UK', FR'}>}Sales)

OR

Sum({<Code = {'GR', 'TR', UK', FR'}>}Sales)

[bobbydave]

where wildmatch(Country, 'GR', 'TR', UK', FR')

That gave me the desired result.

Thanks

[Anil_Babu_Samineni]

Glad to Hear, Close this Thread.