Exclude data problem

[vipin_mishra479]

hiiii, i am upload the qvw file in this file there have a two field vertical and plant

in this qvw i want exclude two plant 2060 and 2080 from Nacelle

[Nicole-Smith]

LOAD * INLINE [

    Vertical, Plant

    Nacelle, 1009

    Nacelle, 1004

    Nacelle, 1005

    Nacelle, 2060

    Nacelle, 2080

    Blade, 2009

    Blade, 1289

    Blade, 1233

    Electrical, 1500

    Electrical, 1555

    Electrical, 2606

    Electrical, 2608

]

WHERE Plant <> 2060 AND Plant <> 2080;

[vipin_mishra479]

but in Electrical i want to show that plant i want to exclude only vertical = Nacelle

[Nicole-Smith · Accepted solution]

LOAD * INLINE [

    Vertical, Plant

    Nacelle, 1009

    Nacelle, 1004

    Nacelle, 1005

    Nacelle, 2060

    Nacelle, 2080

    Blade, 2009

    Blade, 1289

    Blade, 1233

    Electrical, 1500

    Electrical, 1555

    Electrical, 2606

    Electrical, 2608

]

WHERE if(Vertical = 'Nacelle', Plant <> 2060 AND Plant <> 2080, Plant);