How to Exclude field values

[#1]

Hi All,

if i want to Exclude some of the Field values how do i solve that, maybe with the Like Function?

Name	Surname	Age
John	Deer	29
Moses	Fall	32
Letta Theressa	Joses	25
Hallmark Letta	Moak	50

how do i take out all the Letta in my Table?

[alexandros17]

Load * Where Wildmatch(Name, 'Letta') =0;

SELECT * from MyTable;

Let me know

[Gysbert_Wassenaar]

Where do you want to exclude them? In a front end chart or listbox or do you want to exclude them when you load the data?

In the load script you'd use the Wildmatch function:

LOAD

     Name,

     Surname,

     Age

FROM ...

WHERE NOT Wildmatch(Name, '*Letta*');

[#4]

Hi,

Thanks for Quick Response, i want to do it on my Front end

[anat]

Set analysis-Include excluded values;

Set Analysis To exclude an item

[alexandros17]

If Name is a dimension then:

Use edit and write : If(wildmatch(Name, 'Letta')>0, null(), Name) and check the box "Suppress null values"

[awhitfield]

Hi Thabiso,

Are you actually trying to remove the word 'Letta' from the name OR exclude names that contain the word 'Letta' ?

Andy