← CohortDAG documentation
left panel
| Name | Kind | Shortcut | Tooltip | |
|---|---|---|---|---|
![]() | Nodes | tab | Nodes | |
![]() | Outline | tab | Outline | |
![]() | Review | tab | Review | |
![]() | Pipelines | tab | Pipelines | |
![]() | Search pipelines… | control | ||
![]() | Collapse all | control | ||
![]() | Mine 0 | control | ||
![]() | Save the open session as a pipeline | control | ||
![]() | Starters 5 | control | ||
![]() | Cohort 3 | control | ||
![]() | Load Cohort Baseline Characteristics (Table 1) | control | ||
![]() | Manual of Cohort Baseline Characteristics (Table 1) | control | ||
![]() | Details for Cohort Baseline Characteristics (Table 1) | control | ||
![]() | Load Merge & Summarize (Join → Aggregate → Chart) | control | ||
![]() | Manual of Merge & Summarize (Join → Aggregate → Chart) | control | ||
![]() | Details for Merge & Summarize (Join → Aggregate → Chart) | control | ||
![]() | Load Cohort Builder with Checkpoint (Exclusion → Export) | control | ||
![]() | Manual of Cohort Builder with Checkpoint (Exclusion → Export) | control | ||
![]() | Details for Cohort Builder with Checkpoint (Exclusion → Export) | control | ||
![]() | Survival 1 | control | ||
![]() | Search node types… | control | ||
![]() | Collapse all | control | ||
![]() | Input and output 3 | control | ||
![]() | Add Data Source | control | Data Source — Read a registered table as a starting point for the pipeline. | |
![]() | Node guide for Data Source | control | Node guide for Data Source | |
![]() | Add Export Data | control | Export Data — Materialize the input to a named table (a checkpoint boundary a downstream data_source can read back). | |
![]() | Node guide for Export Data | control | Node guide for Export Data | |
![]() | Add Study Report | control | Study Report — Terminal Study Report node rendered in TypeScript from persisted session results (never Spark SQL): canonical Markdown and self-contained HTML with inline SVG figures, Summary sentences, tables, provenance, and compiled-SQL appendix. | |
![]() | Node guide for Study Report | control | Node guide for Study Report | |
![]() | Clean and transform 7 | control | ||
![]() | Add Filter | control | Filter — Keep only rows matching one or more conditions (SQL WHERE). | |
![]() | Node guide for Filter | control | Node guide for Filter | |
![]() | Add Select | control | Select — Choose, drop, or reorder columns to carry forward (SQL SELECT). | |
![]() | Node guide for Select | control | Node guide for Select | |
![]() | Add Computed Column | control | Computed Column — Add one new column from an expression over existing columns. | |
![]() | Node guide for Computed Column | control | Node guide for Computed Column | |
![]() | Add Data Clean | control | Data Clean — Drop duplicate rows, drop rows containing nulls, and/or fill nulls with a literal. NOTE: only dropDuplicates works schema-free; the per-column options (dropNulls, fillNulls) apply solely when the node carries inputSchemas (the renderer always populates them) — without one the node compiles to a plain SELECT (DISTINCT) passthrough. | |
![]() | Node guide for Data Clean | control | Node guide for Data Clean | |
![]() | Add Derive Columns | control | Derive Columns — Row-wise projection: named output columns from expressions, plus an optional filter. | |
![]() | Node guide for Derive Columns | control | Node guide for Derive Columns | |
![]() | Add Deduplicate | control | Deduplicate — Distinct rows — whole-row, or distinct over a chosen column list. | |
![]() | Node guide for Deduplicate | control | Node guide for Deduplicate | |
![]() | Add Type Cast / Recode | control | Type Cast / Recode — Recast or recode named columns while keeping the rest. NOTE: headless compilation applies the replacements only when the .csp node carries inputSchemas (the renderer always populates them); without a resolved input schema the node compiles to a passthrough. | |
![]() | Node guide for Type Cast / Recode | control | Node guide for Type Cast / Recode | |
![]() | Combine and summarize 6 | control | ||
![]() | Add Join | control | Join — Combine a LEFT and RIGHT input on a key column from each side. | |
![]() | Node guide for Join | control | Node guide for Join | |
![]() | Add Aggregate | control | Aggregate — Group rows and compute summaries — count, sum, avg, min, max (GROUP BY). | |
![]() | Node guide for Aggregate | control | Node guide for Aggregate | |
![]() | Add Window | control | Window — Ranks and running totals over ordered partitions (SQL window functions). Appends one output column. | |
![]() | Node guide for Window | control | Node guide for Window | |
![]() | Add Union | control | Union — Stack the rows of two inputs that share the same columns (set operation). | |
![]() | Node guide for Union | control | Node guide for Union | |
![]() | Add Multi-key Join | control | Multi-key Join — Join a LEFT and RIGHT input on multiple key pairs; any join type incl. LEFT SEMI / LEFT ANTI. | |
![]() | Node guide for Multi-key Join | control | Node guide for Multi-key Join | |
![]() | Add Pivot | control | Pivot — Long → wide reshape: an aggregate over a pivot column, one output column per value. | |
![]() | Node guide for Pivot | control | Node guide for Pivot | |
![]() | Build a cohort 3 | control | ||
![]() | Add Cohort Exclusion | control | Cohort Exclusion — Drop rows whose key matches an exclusion code list (optionally within a time window) — a self LEFT ANTI JOIN. | |
![]() | Node guide for Cohort Exclusion | control | Node guide for Cohort Exclusion | |
![]() | Add Conditional Aggregate | control | Conditional Aggregate — Group and compute conditional aggregates: ever-diagnosed flags, first-onset dates, plain aggregates, first_value, coded status. | |
![]() | Node guide for Conditional Aggregate | control | Node guide for Conditional Aggregate | |
![]() | Add Train / Test Split | control | Train / Test Split — Deterministically partition a cohort into a seeded training or test subset (R 4.x Mersenne-Twister + caret::createDataPartition). | |
![]() | Node guide for Train / Test Split | control | Node guide for Train / Test Split | |
![]() | Statistics and charts 5 | control | ||
![]() | Add Descriptive Stats | control | Descriptive Stats — Baseline "Table 1" — summaries of chosen variables, grouped by a column. | |
![]() | Node guide for Descriptive Stats | control | Node guide for Descriptive Stats | |
![]() | Add Kaplan-Meier Survival | control | Kaplan-Meier Survival — Kaplan-Meier survival curves + log-rank test, grouped by a column. | |
![]() | Node guide for Kaplan-Meier Survival | control | Node guide for Kaplan-Meier Survival | |
![]() | Add Cox Regression | control | Cox Regression — Cox proportional-hazards model — hazard ratios, CIs, concordance. | |
![]() | Node guide for Cox Regression | control | Node guide for Cox Regression | |
![]() | Browse templates | control | ||
![]() | New phase | control | ||
![]() | patients | control | ||
![]() | visits | control | ||
![]() | patients ⋈ visits | control | ||
![]() | Count visits per patient | control | ||
![]() | Visits bar chart Current | control | ||
![]() | Comment on “patients ⋈ visits”… | control | Comment on “patients ⋈ visits”… | |
![]() | Set display name… | control | Set display name… | |
![]() | open | control | ||
![]() | resolved | control | ||
![]() | mine | control | ||
![]() | detached | control | ||
![]() | askedAgent | control | ||
![]() | askedYou | control | ||
![]() | warnings | control |






















































































