Hi all,
I know this is the sql query. But i wanted to know how it works
1. CASE WHEN COS LIKE '%(%' THEN REPLACE(COS,SUBSTRING(COS, CHARINDEX('(', COS), CHARINDEX(')', COS)-CHARINDEX('(', COS)+2),'') ELSE COS END
This is from data-load editor in qliksense , Here duedate is column name and it contains some date values. how does this checksum works here.
2.Due-Date = DATEADD(day, ABS(CHECKSUM(NewId()))% 5, Due-Date);
Thanks.
