Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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);
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;
but in Electrical i want to show that plant i want to exclude only vertical = Nacelle
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);