This content has been marked as final. Show 2 replies
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,