August 2022
Beginner to intermediate
463 pages
9h 22m
Chinese
Content preview from Tableau Prep即学即用
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
｜
149
联合数据
在
Prep Builder
中，可以清楚地看到联合步骤中这些不匹配的字段（见图
17-7
）。
图
17
-
7
：概况窗格中联合步骤过程中不匹配的字段
可以通过选择不匹配的字段，然后单击
Merge Fields
（合并字段）选项菜单来合并
它们（见图
17-8
）。
图
17
-
8
：合并字段选项
17.3
何时联合数据
现在已经看到了如何联合数据，但是应该什么时候进行这个数据操作呢？让我们看
看一些常见的场景，在这些场景中，联合数据是一个很好的策略。
150
｜
第
17
章
17.3.1
月度数据集
在与组织中的其他团队或外部第三方合作时，经常会每月收到需要分析的文档。自
动数据准备流程可以为你节省大量时间，将数据塑造成一致的、有用的分析状态。
然而，如果数据需要随着时间的推移而积累，那么你就需要将文档相互追加。这种
情况下，数据联合是最完美的技术。图
17-9
展示了如何使用联合操作将
York
商店
销售数据从月度销售文档变为单一文档进行分析的过程。
图
17
-
9
：月度数据集联合成一个表
17.3.2
来自网络资源的数据集
从基于网络的资源中汇集相近的数据集，是另一种有价值的文档联合的应用场景。
例如，你可能需要从球队网站的某些个别网页中提取球队名册，并将它们合并在一
起。也可以考虑在数据集中添加
URL
或工作表名称作为参考数据。 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.