Jump to content

left single match join in spotfire

Jaime Serrano Jimenez

Recommended Posts

  • 11 months later...

Hello, Jaime.


Unfortunately, there is no criteria for selecting the row on the right side.

Here is what Spotfire documentation says about it:


"Similar to a left outer join but in case of duplicate matches, only one of the right rows are selected. It is undefined which row that gets selected."

Depending on your data, what you can do is create "fake" calculated columns that only has value once your desired criteria are matched. Then, when you create the join, you can add this as one of your join columns.

Link to comment
Share on other sites

From the documentation:


If there are duplicates of the identifiers, only one value from the new data will be kept, and added to the existing rows. That one row seems to be the one which appeared first in the new data. In the above example, the identifier 'c' is duplicated in the new data, so the first record (c,8) will be used in left single match and the other record(c,9) will not be considered.

Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...