Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a requirement where we want to have year from september to august.Can any one tell us how to do?
Hi,
you are talking about reload (script) ? or on some analysis (expressions) ??
What year is that? Perhaps this?
Load *, If(Year = 2017 and (Month >= 'september' and Month <= 'august'), 1,0) as Flag;
Load Year(Date) as Year,
Date(Month(Date), 'MMMM') as Month
From Table;
from script yusuf
from every year from 1986 to 2050
You can use where condition to restrict the data like my month condition?