2 Replies Latest reply: Mar 30, 2016 4:57 AM by Kirsten Zawierucha RSS

    Flag for an entire month when a day is already flagged

    Kirsten Zawierucha

      Dear community,

       

      I have the following problem:

      Some days do not have sales. I already flagged these days in my script.

       

      LOAD 
      if(IsNull(Sales),1,0) as DayFlag,
      Date
      RESIDENT Temp;
      

       

      Now, I also need to flag the entire month when there is a day without sales (respectively there is a flagged day in that month).

       

      Are there any suggestions how to solve my problem?

       

      Thanks in advance,

      Kirsten