Prelaunch preview. Explore AROS products and skills. Checkout is in sandbox; no real payment.
← CohortDAG documentation

Join two tables and summarise them

How-to · CohortDAG 0.2.9

Load the starter pipeline

Click Pipelines and, under Starters, load Merge & Summarize. It runs on sample data that ships with CohortDAG. Close the results panel and click Arrange Graph.

Load the starter pipeline

Check the join

Select the Join node and open Settings in the inspector. It is an inner join of patients and visits on the patient_id column.

Check the join

Run the pipeline

Click Run All Outputs. CohortDAG compiles the pipeline and runs it on Apache Spark. When the run finishes, close the results panel.

Run the pipeline

Read the joined rows

Run All Outputs computes only the pipeline's outputs, so the Join node's own rows are not stored yet. Select the Join node, open the Workspace tab and click Run Selected. Each row now carries the columns of the patient and of the visit.

Read the joined rows