注意:以下翻译的准确性尚未经过验证。这是使用 AIP ↗ 从原始英文文本进行的机器翻译。
支持于: 批处理
笛卡尔积合并将左侧和右侧数据集输入合并在一起,将每一侧的所有行与另一侧的所有行匹配。输出是两个数据集的笛卡尔积。
变换类别: 合并
参数值:
输入: ri.foundry.main.dataset.left
tail_number | airline | miles | factor |
---|---|---|---|
XB-123 | foundry air | 124 | 2 |
MT-222 | new airline | 1123 | 5 |
PA-452 | new air | 212 | 2 |
ri.foundry.main.dataset.right
tail_number | home_airport |
---|---|
XB-123 | LHR |
MT-222 | CPH |
KK-452 | JFK |
JR-201 | IAD |
输出:
tail_number | airline | home_airport |
---|---|---|
XB-123 | foundry air | LHR |
XB-123 | foundry air | CPH |
XB-123 | foundry air | JFK |
XB-123 | foundry air | IAD |
MT-222 | new airline | LHR |
MT-222 | new airline | CPH |
MT-222 | new airline | JFK |
MT-222 | new airline | IAD |
PA-452 | new air | LHR |
PA-452 | new air | CPH |
PA-452 | new air | JFK |
PA-452 | new air | IAD |
参数值:
输入: ri.foundry.main.dataset.left
tail_number | airline | miles | factor |
---|---|---|---|
XB-123 | foundry air | 124 | 2 |
MT-222 | new airline | 1123 | 5 |
PA-452 | new air | 212 | 2 |
ri.foundry.main.dataset.right
tail_number | home_airport |
---|---|
XB-123 | LHR |
MT-222 | CPH |
KK-452 | JFK |
JR-201 | IAD |
输出:
tail_number | airline | miles | factor | home_airport |
---|---|---|---|---|
XB-123 | foundry air | 124 | 2 | LHR |
XB-123 | foundry air | 124 | 2 | CPH |
XB-123 | foundry air | 124 | 2 | JFK |
XB-123 | foundry air | 124 | 2 | IAD |
MT-222 | new airline | 1123 | 5 | LHR |
MT-222 | new airline | 1123 | 5 | CPH |
MT-222 | new airline | 1123 | 5 | JFK |
MT-222 | new airline | 1123 | 5 | IAD |
PA-452 | new air | 212 | 2 | LHR |
PA-452 | new air | 212 | 2 | CPH |
PA-452 | new air | 212 | 2 | JFK |
PA-452 | new air | 212 | 2 | IAD |