Skip to main contentYou 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
