4 Replies Latest reply: May 4, 2018 7:37 AM by Sasidhar Parupudi RSS

    FILTERING WILD CARD IN DATA LOAD

    Ashley Kuttler

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