Create a calculated column in Spotfire

In this video, we will explore how to create a column based on a condition in another column in less than 3 minutes in the Spotfire Data Canvas. This technique uses the CASE WHEN syntax and is suitable for beginner Spotfire users.
Want to learn more? Check out the Spotfire Community at community.spot....
Want to request other QuickTip videos? You can submit requests on the Dr. Spotfire Club: community.spot...
1:21 - Case When Expression
2:27 - Add new column to the Table Visualization

[@culdeus9559]

For the case expression would advise always having an else = "error" in case you have garbage data.