show all except one

[soniasweety]

Hi all

I have a data like below

Country	Capital city
United Arab Emirates	Abu Dhabi
United Kingdom	London
United States of America	Washington, D.C.
Uruguay	Montevideo

india        karnataka

india  pune

india  kolkatha

here my requirement is  like     I want to display the result      india =Karnataka  and rest all should display    [inida=pune and kolkatha  should not display ]

how to achieve this?

[Anil_Babu_Samineni]

May be this?

Load Country, [Capital city] from Table where Country = 'india' and [Capacity city] = 'karnataka';

[OmarBenSalem]

sthing like:

sum({<"Capital City" -= {'pune','kolkatha'}>}YourMeasure)

[soniasweety]

It will give only  Karnataka data only na  ... I want other data should display 

[OmarBenSalem]

if u want to have only karnataka as ur only capital city fo india and not having to deal with the other 2; then do not import them in ur script:

I mean, sthing like:

load

Country,

"Capital city" from source where "Capital city"<>'pune'  and "Capital city"<>'kolkatha';

[Anil_Babu_Samineni · Accepted solution]

This will deserve

Load Country, [Capital city] from Table where Not WildMatch([Capacity city], 'pune', 'kolkatha');

[devarasu07]

Hi,

back end method 1,

Fact:

LOAD * INLINE [

    Country, Capital city

    United Arab Emirates, Abu Dhabi

    United Kingdom, London

    United States of America, "Washington, D.C."

    Uruguay, Montevideo

    india,karnataka,

    india,pune,

    india,kolkatha,

] where not Match([Capital city],'pune','kolkatha');

Method 2;

u can also add front end dimension Country, city as calculated dim

=if(not Match([Capital city],'pune','kolkatha'),[Capital city])

[Anil_Babu_Samineni]

Try to close this thread, If issue got resolved by flag "Correct Answer"

[shivanisali]

Try this:

LOAD * INLINE [

    country, city

    United Arab Emirates, Abu Dhabi

    United Kingdom, London

    United States of America, "Washington, D.C."

    Uruguay, Montevideo

    india        , karnataka

    india  , pune

    india, kolkatha

]

where country <>'india' or city<>'pune' and city<>'kolkatha';

[soniasweety]

Thanks all all suggestions good it worked well