188125_en-US

liliconcom

JMP Query Builder JMP Pro 13_Unable to build Query

Dear All,

 

I have two JMP tables. I am trying to build a query in which I need to keep rows where product 1 from table 1 match the product 2 active ingredient in table 2. However, when I select table 1 as primary and table 2 as secondary or vise versa the Build Query disabled. The two tables have no common column name between them.

 

May I ask your help in this case, please?

 

 

Re: JMP Query Builder JMP Pro 13_Unable to build Query

If the auto-join does not work, you can click the "Edit Join" button to specify a mapping between the tables:

 

 

Will this work for your situation?