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;





      MONTH([XXXX_date])= 10


      (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)



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

      thanks in advance,