| id |
dt |
type |
grp |
typecol1 |
typecol2 |
typecol3 |
typecol4 |
| 1 |
15/01/2019 00:00:00 |
1 |
1 |
A |
null |
null |
null |
| 2 |
15/01/2019 00:00:00 |
2 |
2 |
null |
B |
null |
null |
| 3 |
15/01/2019 00:00:00 |
3 |
3 |
null |
null |
C |
null |
| 4 |
15/01/2019 00:00:00 |
4 |
4 |
null |
null |
null |
D |
| 5 |
15/02/2019 00:00:00 |
1 |
1 |
AA |
null |
null |
null |
| 6 |
15/02/2019 00:00:00 |
4 |
2 |
null |
null |
null |
DD |
| 7 |
15/03/2019 00:00:00 |
3 |
1 |
null |
null |
CCC |
null |
| 8 |
15/04/2019 00:00:00 |
2 |
1 |
null |
BBBB |
null |
null |
| dt |
typecol1 |
typecol2 |
typecol3 |
typecol4 |
| 15/01/2019 00:00:00 |
A |
B |
C |
D |
| 15/02/2019 00:00:00 |
AA |
null |
null |
DD |
| 15/03/2019 00:00:00 |
null |
null |
CCC |
null |
| 15/04/2019 00:00:00 |
null |
BBBB |
null |
null |
Warning: Null value is eliminated by an aggregate or other SET operation.