Home
Random
Log in
Settings
About Rosetta Code
Disclaimers
Rosetta Code
Search
Merge and aggregate datasets: Difference between revisions
Language
Watch
View source
← Older edit
Newer edit →
Content deleted
Content added
Revision as of 12:31, 7 June 2021
view source
Mark Clements
(
talk
|
contribs
)
136
edits
→{{header|TutorialD}}
← Older edit
Revision as of 13:20, 7 June 2021
view source
Mark Clements
(
talk
|
contribs
)
136
edits
m
→{{header|TutorialD}}
Newer edit →
Line 1,573:
};
((
summarize
SUMMARIZE
(visit
where
WHERE
score>0.0)
by
BY
{id}: {sumscore :=
sum
SUM
(score), avgscore :=
avg
AVG
(score)})
union
UNION
(
extend
EXTEND
(patient {id}
minus
MINUS
((visit
where
WHERE
score>0.0) {id})): {sumscore
:=
NaN, avgscore
:=
NaN}))
join
JOIN
(
summarize
SUMMARIZE
visit
by
BY
{id}: {maxdate :=
max
MAX
(date)}
union
UNION
(
extend
EXTEND
(patient {id}
minus
MINUS
(visit {id})): {maxdate := DateUnknown()}))
join
JOIN
patient</lang>
{{out}}