Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Team,
Require you help to know how to calculate 7 day sliding window date range .
The 7 day logic means a cell is classified according to if in the last 7 days the classification logic comes out TRUE.
So for each day you look at the 6 days previous to the day + the day considered (total of 7 days) and then do the logic and decide which classification is TRUE for that day.
Classification is of 4 types:
a)ALARMED
B)HIGH
C)STANDARD
D)LOW
I:E I nned to mark each date with this 4 classification based on above logic.
sAMPLE EXCEL ATTACHED WITH CLASSIFICATION LOGIC.
can you please advice how to do this ?
Dear Gysbert,
This is in some other context.
Inned to achive tow things:
a) Load only new files in a folder each hour .Do not load files which are aleardy loaded?
I read several post related to incremental reload but did not get anything which say that how to skpi files which are already loaded.
I don't want to keep qvd of each file read as it just incremeases the disk space.
Can you please advice .
Dear Gysbert,
This is in some other context.
Inned to achive tow things:
a) Load only new files in a folder each DAY .Do not load files which are aleardy loaded?
I read several post related to incremental reload but did not get anything which say that how to skpi files which are already loaded.
I don't want to keep qvd of each file read as it just incremeases the disk space.
Can you please advice .