2 Replies Latest reply on Jun 10, 2018 5:38 PM by Masako Takata

    How to apply Row Filter

    Masako Takata

      Hi all, I'm trying to use Prep.

       

      I would like to select some data from DB (Teradata).

      since the table contains several years data and i need only specific day~week, i want to apply Row Filter.

      it didn't allow to put string (e.g., "10/01/2017 00:00:00"), so i set as following;

       

       

      YEAR([XXXX_date])=2017

      AND

      MONTH([XXXX_date])= 10

      AND

      (DAY([XXXX_date])= 1

      )

       

      it is grammatically correct, and it returns sample data.

      however, there was no data shown in next step (in picture, number 2)

      filter.png

       

      is the filter setting wrong? if so, please tell how to.

      thanks in advance,