FILTERING WILD CARD IN DATA LOAD

[akuttler]

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,'**');

[Chanty4u]

try

WHERE PracticeName NOT like '**';

[Digvijay_Singh]

Where not index(PracticeName,'*');

[sunny_talwar]

or even this

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

[sasiparupudi1]

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;