Hi,

I am facing this issue as the field after being aggregated by the function 'list' in the taggregate rows

i have this scenario where 1 student many activities
so for an particular activity i have to use list & ignore null

like for example

i/p schema (2 tables student & activity):
student
id name age
1 ron       14
2 sam      13

activity
id activity_name  position value
1   football          fwd
1   studies                       75
2   sam                           60



o/p schema

id name age football studies
1  ron   14    fwd        75
2  sam  13    ''           60


now as sam doesnt have football as activity '' is displayed but null is expected, any ans why '' coming


aggregaterow func
football     list
studies     sum

ignore null checked

any help here

thx & regards,
jugal