First union by name（按首个数据集名称合并（First union by name））

Supported in: Batch, Faster

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\

  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	airline_code
  true	KK-150	KK
  false	XB-120	XB
  true	MT-190	MT

  ri.foundry.main.dataset.b

  recently_serviced	tail_number	home_country
  true	AA-200	US
  true	BN-435	UK
  true	BN-111	UK

  Output:

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

  ---

  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

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

  ri.foundry.main.dataset.b

  home_country	tail_number	recently_serviced
  US	AA-200	true
  UK	BN-435	true
  UK	BN-111	true

  ri.foundry.main.dataset.c

  home_country	tail_number
  DK	SK-908
  CH	LX-17
  IN	AI-144

  Output:

  recently_serviced	tail_number	airline_code
  true	KK-150	KK
  false	XB-120	XB
  true	MT-190	MT
  true	AA-200	null
  true	BN-435	null
  true	BN-111	null
  null	SK-908	null
  null	LX-17	null
  null	AI-144	null

  ---

  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

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

  ri.foundry.main.dataset.b

  Output:

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

  ---

  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

  recently_serviced	tail_number	airline_code
  null	null	null

  ri.foundry.main.dataset.b

  recently_serviced	tail_number	home_country
  null	null	null

  Output:

  recently_serviced	tail_number	airline_code
  null	null	null
  null	null	null

  ---

  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

  recently_serviced	tail_number	airline_code

  ri.foundry.main.dataset.b

  recently_serviced	tail_number	home_country

  Output:

  recently_serviced	tail_number	airline_code

  ---

  Example 6: Edge case

  Argument values:

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

  Input:

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

  Output:

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

  ---

  ---

  中文翻译

  ---

  按首个数据集名称合并（First union by name）

  支持：批处理（Batch）、快速（Faster）

  将多个数据集按照首个数据集的列进行合并，当某些列缺失时自动填充空值（null）。不在首个数据集中的列将被移除。

  转换类别：连接（Join）

  声明参数

  • 待合并数据集（Datasets to union）： 需要合并在一起的数据集。
    列表\<表>

  示例

  示例 1：基础情况

  参数值：

  • 待合并数据集： [ri.foundry.main.dataset.a, ri.foundry.main.dataset.b]

  输入：

  ri.foundry.main.dataset.a

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

  ri.foundry.main.dataset.b

  recently_serviced	tail_number	home_country
  true	AA-200	US
  true	BN-435	UK
  true	BN-111	UK

  输出：

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

  ---

  示例 2：基础情况

  参数值：

  • 待合并数据集： [ri.foundry.main.dataset.a, ri.foundry.main.dataset.b, ri.foundry.main.dataset.c]

  输入：

  ri.foundry.main.dataset.a

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

  ri.foundry.main.dataset.b

  home_country	tail_number	recently_serviced
  US	AA-200	true
  UK	BN-435	true
  UK	BN-111	true

  ri.foundry.main.dataset.c

  home_country	tail_number
  DK	SK-908
  CH	LX-17
  IN	AI-144

  输出：

  recently_serviced	tail_number	airline_code
  true	KK-150	KK
  false	XB-120	XB
  true	MT-190	MT
  true	AA-200	null
  true	BN-435	null
  true	BN-111	null
  null	SK-908	null
  null	LX-17	null
  null	AI-144	null

  ---

  示例 3：基础情况

  参数值：

  • 待合并数据集： [ri.foundry.main.dataset.a, ri.foundry.main.dataset.b]

  输入：

  ri.foundry.main.dataset.a

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

  ri.foundry.main.dataset.b

  输出：

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

  ---

  示例 4：空值情况

  参数值：

  • 待合并数据集： [ri.foundry.main.dataset.a, ri.foundry.main.dataset.b]

  输入：

  ri.foundry.main.dataset.a

  recently_serviced	tail_number	airline_code
  null	null	null

  ri.foundry.main.dataset.b

  recently_serviced	tail_number	home_country
  null	null	null

  输出：

  recently_serviced	tail_number	airline_code
  null	null	null
  null	null	null

  ---

  示例 5：边界情况

  参数值：

  • 待合并数据集： [ri.foundry.main.dataset.a, ri.foundry.main.dataset.b]

  输入：

  ri.foundry.main.dataset.a

  recently_serviced	tail_number	airline_code

  ri.foundry.main.dataset.b

  recently_serviced	tail_number	home_country

  输出：

  recently_serviced	tail_number	airline_code

  ---

  示例 6：边界情况

  参数值：

  • 待合并数据集： [ri.foundry.main.dataset.a]

  输入：

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

  输出：

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

  ---