I have to join two tables using jsl. The first table looks like this:
However, the second table can either be like this:
![Example2.PNG Example2.PNG](https://community.jmp.com/t5/image/serverpage/image-id/9859i1F2F1E9ECD6916C2/image-size/large?v=v2&px=999)
In this table, Pred Form Molecule 1 (%)(2) is the same as Molecule 1(%) and the numbers in the value column are repeated. How can I specify the join to only consider one of those values?
The second table to join can look like this:
![Example3.PNG Example3.PNG](https://community.jmp.com/t5/image/serverpage/image-id/9860i1B558E2EBABB80F1/image-size/large?v=v2&px=999)
In this case, how can I specify in the join that Molecule 1 (%) in the first table is the same as Pred Form Molecule1 (%)(2) in the table that needs to be joined.
The final table that I need should be something like this:
Thank you for any help.