Jay Wu Posted August 4, 2021 Posted August 4, 2021 I was wondering if you know there is any way that Spotfire can do the following Table 1 (main table) in the attachment is the main table, Table 2 is the supporting table. Is there any method that Spotfire can transform and combine those 2 tables into the tab Goal.
Fabian Duerr Posted August 8, 2021 Posted August 8, 2021 There is no built-in join method for this operation. But you can solve this with a data function. Both tables would be input to your function and the output could be a new table. Your function has to loop thru every row in "table 1", get the ID and value and then check in "table 2" in the row with this ID for the smallest difference to the value. The resulting vector can then be added as column to "table 1" to create your output table "goal". Alternatively you could transpose your "table 2" and use some kind of fuzzyjoin (R package) to get the same result. Do you have experience with data functions or do you need further assistance
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