Skip to main content
You will very often find yourself wanting to add new columns to your dataset. In this lesson, we’ll cover the New Column tool. This is a very versatile tool that can be used in a lot of different ways.

​
Exercise

We’re working with the ORDERS dataset and you want to get the result shown below. We ended up with 227.597 rows and used five tools to get the result. A couple of hints. You can round numeric columns in a couple of ways: with the Transform tool or with the .ROUND syntax. The TEXT() function could also be helpful to convert a number to a string - you can also use the Column tool if you prefer.
We use a 0.85 exchange rate to go from USD to EUR. We only want orders that are currently fulfilled (F in the O_ORDERSTATUS column) and where the order is placed on or after 1994-01-01 and before or on 1994-12-31.

​
Solution