JMP script for Joining data tables using contain function

[#1]

Hi All,

I have 2 data table shows as below, need to join based on 2 matches, were place  will be 100% match and the second column to be matched will be a truncated version  from first

Please help here to join data table based on 2 column, taking 2 column under consideration

jinsejoseph_0-1651210814669.pngjinsejoseph_1-1651210822453.png

[#2 · Accepted solution]

The online help gives an example of a join based on multiple columns:

https://www.jmp.com/support/help/en/16.2/?os=mac&source=application#page/jmp/examples-of-joining-dat...

scroll down to 'Examples of Joining By Matching Columns'.

Your title says you want a JSL script - well its hard to build a script if you don't know how to do it interactively in JMP.  And once you can do that JMP will give you the script (check the 'source' script in the output table, or the log window if you are using JMP 16).