Merge and aggregate datasets: Difference between revisions

Content added Content deleted

Inline

@@ Line 1,573: / Line 1,573: @@
 };
-((summarize (visit where score>0.0) by {id}: {sumscore := sum(score), avgscore := avg(score)}) union
+((SUMMARIZE (visit WHERE score>0.0) BY {id}: {sumscore := SUM(score), avgscore := AVG(score)}) UNION
- (extend (patient {id} minus ((visit where score>0.0) {id})): {sumscore:=NaN, avgscore:=NaN})) join
+ (EXTEND (patient {id} MINUS ((visit WHERE score>0.0) {id})): {sumscore := NaN, avgscore := NaN})) JOIN
-    (summarize visit by {id}: {maxdate := max(date)} union
+    (SUMMARIZE visit BY {id}: {maxdate := MAX(date)} UNION
-     (extend (patient {id} minus (visit {id})): {maxdate := DateUnknown()})) join
+     (EXTEND (patient {id} MINUS (visit {id})): {maxdate := DateUnknown()})) JOIN
     patient</lang>
 {{out}}