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.
｜
227
拆分数据字段
25.2
高级拆分：当自动拆分不能如期进行的时候
让我们稍微调整一下数据，使定界符的模式（我们用字符分割数据字段）对
Prep
Builder
来说不那么明显（见图
25-6
）。
图
25
-
6
：修改后的数据集，其定界符对 Prep Builder 来说并不清晰
现在，肥皂棒的
Product Type
（产品类型，位于产品代码的第一部分）不再包含肥
皂一词，每个字段现在都包含连字符周围的空格。有了这种不规则的模式，
Prep
不
再能提供我们想要的结果（见图
25-7
）。
图
25
-
7
：图
25
-
6
中数据集自动拆分的结果
228
｜
第
25
章
在这次拆分后的数据集中，
Product Type
（产品类型）已经完全看不到了。注意到所
有这些空白记录了吗？它们是由于肥皂棒数据集的行数据中删除了
Soap
（肥皂）字
样的结果，注意液体皂数据集的行数据中没有空白记录。让我们看看
Prep
为这个拆
分所写的计算结果（见图
25-8
）。
图
25
-
8
：使用 Calculation Editor（计算编辑器）来理解拆分问题
好吧，这下明白了，对吧？
这种情况下，你的眼睛就可以接管了，此时应该选择
Custom Split
（定制拆分）菜
单选项，而不是
Automatic Split
（自动拆分）。通过设置定制拆分对连字符的处理，
又可以从这个数据集中得到我们想要的结果了（见图 ...
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.