Dear All, I have a problem in running total data in script load.
So have any solution for this case or not?
My data like below:
Data2:
Load * Inline [
date, flag, pic
1, 1, a
2, 1, a
4, 0, a
5, 0, a
7, 1, a
9, 1, a
10, 1, a
1, 0, b
2, 1, b
3, 1, b
4, 1, b
5, 0, b
6, 0, b
3, 0, c
4, 1, c
5, 1, c
6, 0, c
7, 0, c
];
My problem: Generate field [flag within 3 previous days] : at current row of [date] field, mark 1 for [flag within 3 previous days] if in 3 previous days have [flag]=1 for each group of [pic]
My expected result:
| date | pic | flag | flag within 3 previous days |
| 1 | a | 1 | 1 |
| 2 | a | 1 | 1 |
| 3 | a | 1 | 1 |
| 4 | a | 1 | 1 |
| 5 | a | 0 | 0 |
| 6 | a | 0 | 0 |
| 7 | a | 1 | 1 |
| 8 | a | 1 | 1 |
| 9 | a | 1 | 1 |
| 10 | a | 1 | 1 |
| 1 | b | 0 | 0 |
| 2 | b | 1 | 1 |
| 3 | b | 1 | 1 |
| 4 | b | 1 | 1 |
| 5 | b | 1 | 1 |
| 6 | b | 1 | 1 |
| 7 | b | 0 | 0 |
| 8 | b | 0 | 0 |
| 3 | c | 0 | 0 |
| 4 | c | 1 | 1 |
| 5 | c | 1 | 1 |
| 6 | c | 1 | 1 |
| 7 | c | 1 | 1 |
| 8 | c | 0 | 0 |
| 9 | c | 0 | 0 |
