i found the reason why its comin '', because i selected list operation & there was no value of football for sam i.e id=2
the inserted value in db is empty string i.e ""

1 way to alter this is to use treplace after aggregaterows & replace "" with null

can u suggest some other way

regards,
djugal

Hi Jugal

I try to reproduce this issue by using DB2 and Postgresql, but failed.

So I guess this is due to the data in your DB. Or you'd better run this job with other TOS version.

Regards,
Pedro

Hi

I created a job using the data above and didn't get '' in result.

Which version of TOS do you use?
Could you upload the screenshot of your job?

Regards,
Pedro

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