今天就开通帐号，24,700 门业界名师课程任您挑！
Add multiple columns to a table using records: Example 1
- [Instructor] Adding custom columns while transforming your data is a very, very common exercise. Now in case you have a lot of columns to add in your transformations, your query is going to look something like this, which is where you will obviously have a lot of added custom steps. But we can make it a lot more easier by using records and make the query shorter and make it look like this instead and still have all of those columns added in just one go. This is going to be a very interesting exercise. Let's start. All right, I'm in this Excel file, and that's where I have a data of four simple columns. We have the date column, the stock column, the purchase value, and the current value column. To this data, we'd like to add four additional calculated custom columns to this, and the logic is very, very simple. The first column that we would want to add to this data is the commission column, which is where I will take my purchase value, whatever that value might be, and give 10%…
随堂练习，边学边练
下载课堂讲义。学练结合，紧跟进度，轻松巩固知识。
下载课程离线学习
下载课程到移动设备，轻松离线学习。在领英学习 iOS 或安卓版 APP 下载课程