topic Re: Exclude Specific Word From Results in QlikView

Exclude Specific Word From Results

Mon, 20 Jun 2016 11:45:43 GMT

I have a table for all project names and the resources names for each project, I want to exclude every resource from the table that contains the word "Vendor" in it's name

Re: Exclude Specific Word From Results

m_woolf — Mon, 20 Jun 2016 12:15:10 GMT

Load

From TableName

where index(Resource,'Vendor') = 0;

Re: Exclude Specific Word From Results

Anonymous — Mon, 20 Jun 2016 12:19:52 GMT

Hi Talal,

LOAD

WHERE SubStringCount(Upper(Resource),'VENDOR') = 0;

Regards!!

Re: Exclude Specific Word From Results

tamilarasu — Mon, 20 Jun 2016 13:22:41 GMT

One more solution,

LOAD *

Where WildMatch(Resource,'*Vendor*') =0;

Where Not WildMatch(Resource,'*Vendor*');