topic Re: String Function to Exclude in QlikView

String Function to Exclude

Wed, 25 Jan 2012 18:07:03 GMT

Hi,

I have a resident table which has a column name.I need to create a new table excluding name that starts with XXX.How to do it?

New table

Thanks...

Wed, 25 Jan 2012 18:41:59 GMT

Hi Pooja,

try this

load

num,

name

resident table1 where not wildmatch(name,'XXX*');

this will give you all the names which does not start with XXX;

table1 here is your original table, which you have already loaded. change this to your table name.

let me know, if you face any issue.

........

regards,

Ashutosh

Wed, 25 Jan 2012 19:05:19 GMT

Thank You so much Ashutosh..It worked.