Wide union by name（按名称宽联合 (Wide union by name)）

Supported in: Batch, Faster, Streaming

Unions a set of datasets together on the superset of their column names, adding nulls when columns are missing.

Transform categories: Join

Declared arguments

• Datasets to union: The datasets being unioned together.
  List\

  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

  recently_serviced	tail_number
  true	KK-150
  false	XB-120
  true	MT-190

  ri.foundry.main.dataset.b

  recently_serviced	tail_number	airline_code
  true	AA-200	AA
  true	BN-435	BN
  true	BN-111	BN

  Output:

  recently_serviced	tail_number	airline_code
  true	KK-150	null
  false	XB-120	null
  true	MT-190	null
  true	AA-200	AA
  true	BN-435	BN
  true	BN-111	BN

  ---

  ---

  中文翻译

  ---

  按名称宽联合 (Wide union by name)

  支持：批处理 (Batch)、快速处理 (Faster)、流处理 (Streaming)

  将一组数据集基于其列名的超集进行联合，当缺少某列时自动填充空值。

  转换类别：连接 (Join)

  声明参数

  • 要联合的数据集 (Datasets to union)： 被联合在一起的数据集。
    列表\<表> (List\)

    示例

    示例 1：基础情况

    参数值：

    • 要联合的数据集 (Datasets to union)： [ri.foundry.main.dataset.a, ri.foundry.main.dataset.b]

    输入：

    ri.foundry.main.dataset.a

    recently_serviced	tail_number
    true	KK-150
    false	XB-120
    true	MT-190

    ri.foundry.main.dataset.b

    recently_serviced	tail_number	airline_code
    true	AA-200	AA
    true	BN-435	BN
    true	BN-111	BN

    输出：

    recently_serviced	tail_number	airline_code
    true	KK-150	null
    false	XB-120	null
    true	MT-190	null
    true	AA-200	AA
    true	BN-435	BN
    true	BN-111	BN

    ---