Balasundhari Balasubramaniyan 2 Posted July 1, 2021 Share Posted July 1, 2021 Hi, If col1 cell1 value is in col2 any cell then I want return value true else false. How can I calculate this in spotfire what is the equivalent of excel(match&vlookup) in spotfire Col1 col2 cal col A Z True B A #N/A C X #N/A D D True Link to comment Share on other sites More sharing options...
Fabian Duerr Posted July 2, 2021 Share Posted July 2, 2021 You can create a very simple TERR data function. Just one line of code: Input parameter 1 (a column): Col1 Input parameter 2 (a column): Col2 Output parameter (a column): CalCol Script: CalCol Link to comment Share on other sites More sharing options...
Anders Gavare Posted July 5, 2021 Share Posted July 5, 2021 Note that this can also be written inline when creating a calculated column, without having to explicitly add it as a Data Function: TERR_Boolean("output <- input1 %in% input2", [Col1], [Col2]) Link to comment Share on other sites More sharing options...
Fabian Duerr Posted July 5, 2021 Share Posted July 5, 2021 Thank you for this hint :) Link to comment Share on other sites More sharing options...
Balasundhari Balasubramaniyan 2 Posted July 8, 2021 Author Share Posted July 8, 2021 Thanks for your suggestion. Also this is achievable using below expression UniqueConcatenate([col2])~=[col1] UniqueConcatenate([col2]) over ([coln])~=[col1] Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now