Unwanted Field

[oseimuduame]

Good Afternoon,

Is it possible to Exclude a particular field from the Database, i tried doing it with WHERE NOT but it only excludes the name of the Field but showing other attributes of the field.

Thank You.

[vinieme12]

if you know what fields are to be loaded, then specify all fields in the LOAD statement

if you only know what fields are to be excluded then drop them after the table load

example

Drop fields fielda,field2,.....;

[oseimuduame]

i will try that but lets take for example i have a field that contains Column that contains Mango, Apple, Orange and Ball, but i want to fetch all items except Ball.

Thats what i meant. How can i fetch all items and ecxlude just Ball from my selection.

i used WHERE NOT Description = 'the Name of the Item(BAll);',

Please i need assistance

[vinieme12]

WHERE Wildmatch(FieldName,'Ball')=0;

[oseimuduame]

What i am getting in SQL Script Editor is Invalid Identifier.

[vinieme12]

please post the script you are using

[oseimuduame]

Lemme show you what

Now from the above table i want to exclud the row thats holding LPG BUTANE and so that i will only have my Gas Refill.

Any idea how that can be done

[vinieme12]

in Qlikview LOAD statement

Load *

From XXX

WHERE WildMatch(ItemName,'LPG Butane')=0;

[vinieme12]

i think you are adding the where clause in the Select statement instead of Load , if you post your script i can tell you where to place it

[awhitfield]

Where are you loading you r data from ?

Andy