In Spotfire, you cannot join on a calculated column. The calculated column will not appear in the list of columns in the Insert Columns dialog. This limitation is by design, as calculated columns can change during the course of the analysis, which could change the rows to be returned. The way to get around this is create the calculated column as part of a transformation, as transformations only occur once when the DXP is opened and therefore, can't change the way regular calculated columns can. In order to use a calculated column in a join, create the calculation as part of a transformation (Insert, Transformations, Calculated column).
Modified on: Mon, 3 Oct, 2016 at 3:00 PM
Did you find it helpful?Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.