Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

akuttler
Contributor

FILTERING WILD CARD IN DATA LOAD

Hi,

I am attempting to filter out fields that contain an '*' in my dataload, but its filtering out everything.

LOAD

     "DATE" as Date,

      Year ("DATE") as Year,

    MEMO,

    CREDIT,

    PracticeName

FROM [lib://NNS ANALYTICS/MASTER Daily Bank Statements BACKUP.xlsx]

(ooxml, embedded labels, table is [2018])

WHERE NOT WildMatch(PracticeName,'**');

Tags (1)
4 Replies
sureshqv
Esteemed Contributor III

Re: FILTERING WILD CARD IN DATA LOAD

try

WHERE PracticeName NOT like '**';


Digvijay_Singh
Honored Contributor III

Re: FILTERING WILD CARD IN DATA LOAD

Where not index(PracticeName,'*');

Re: FILTERING WILD CARD IN DATA LOAD

or even this

Where SubStringCount(PracticeName, '*') = 0;

sasiparupudi1
Honored Contributor III

Re: FILTERING WILD CARD IN DATA LOAD

another way

LOAD

     "DATE" as Date,

      Year ("DATE") as Year,

    MEMO,

    CREDIT,

    PracticeName

FROM [lib://NNS ANALYTICS/MASTER Daily Bank Statements BACKUP.xlsx]

(ooxml, embedded labels, table is [2018])

WHERE Len(Keepchar(PracticeName,'**'))=0;

Community Browser