Let's say you want to group multiple values together into a single value. 

E.g. you have a column containing countries and want to treat Canada and the US as one single value called North America.


(1) Click New Column
Give your column a name (e.g. region)
(3) Add the following expression:

if (country == "United States" or country == "Canada") then "North America" else country.

*change country to the name of the column containing the country values.

(4) Click Done.

All done! 👨‍🚀

You now have a new column that contains "North America" in rows where the country is Canada or the United States!


(In SQL, you would do the above using a Case Statement)

Did this answer your question?