2 Replies Latest reply: Sep 28, 2017 11:27 PM by Anand Chouhan RSS

    How to make Filters on dates with conditions ? (conditional load)

    Ali Bouderbala

      Hi experts ,

      How to make Filters on dates with conditions ? (conditional load)Please see The attached sample ?

       

      Request: i want to make a filter and load data with [Date Extract] -30 days and where Date Extract> Date creation

       

      Table:

      LOAD [Date Extract],

           [Date creation],

           [Champ Num],

           [Champ Text],

           [Date Extract]-30 as date_Extract

        

      //Date extract //Minus 30 Days dateext.PNG

      //Filter where date_Extract>Date creation

       

       

      FROM

      C:\Users\Desktop\Tablemodele.xlsx