First union by name

Supported in: Batch

Unions a set of datasets together on columns from the first dataset, adding nulls when columns are missing. Columns that are not present in the first dataset are removed.

Transform categories: Join

Declared arguments

• Datasets to union: The datasets being unioned together.
  List<Table>

Examples

Example 1: Base case

Argument values:

• Datasets to union: [ri.foundry.main.dataset.a, ri.foundry.main.dataset.b]

Inputs: ri.foundry.main.dataset.a

ri.foundry.main.dataset.b

Output:

---

Example 2: Base case

Argument values:

• Datasets to union: [ri.foundry.main.dataset.a, ri.foundry.main.dataset.b, ri.foundry.main.dataset.c]

Inputs: ri.foundry.main.dataset.a

ri.foundry.main.dataset.b

ri.foundry.main.dataset.c

Output:

---

Example 3: Base case

Argument values:

• Datasets to union: [ri.foundry.main.dataset.a, ri.foundry.main.dataset.b]

Inputs: ri.foundry.main.dataset.a

ri.foundry.main.dataset.b

| |

Output:

---

Example 4: Null case

Argument values:

• Datasets to union: [ri.foundry.main.dataset.a, ri.foundry.main.dataset.b]

Inputs: ri.foundry.main.dataset.a

ri.foundry.main.dataset.b

Output:

---

Example 5: Edge case

Argument values:

• Datasets to union: [ri.foundry.main.dataset.a, ri.foundry.main.dataset.b]

Inputs: ri.foundry.main.dataset.a

ri.foundry.main.dataset.b

Output:

---

Example 6: Edge case

Argument values:

• Datasets to union: [ri.foundry.main.dataset.a]

Input:

Output:

---