topic Re: Question: Can JMP do a Full Outer Join without renaming the fields (scripting, info) in Discussions

Question: Can JMP do a Full Outer Join without renaming the fields (scripting, info)

Newbie2Jumpie — Fri, 28 Jun 2019 05:29:53 GMT

Hi,

Recently I did a Full Outer Join (inluding nonmatches). Imagine my surpirse when i found that JMP renamed all fields during the join by adding the name of the source table. Can JMP do a Full Outer Join without renaming? If I could do that just using a nondocumented) option, just let me know.

The JSL I used was something like, asuming "A" is already open:

dt << Join

(        with (data table("B") ),

         select(),

         selectwith(),

         include nonmatches(),

         by matching columns(IDENTA=IDENTB)

);

Cheers!

Newbie

Re: Question: Can JMP do a Full Outer Join without renaming the fields (scripting, info)

txnelson — Fri, 28 Jun 2019 08:24:32 GMT

You can use the "Merge Same Name Columns".

dt << Join

(        with (data table("B") ),

         merge same name columns,

         select(),

         selectwith(),

         include nonmatches(),

         by matching columns(IDENTA=IDENTB)

);

You need to take the time to read the JSL documentation in the Scripting Guide

Help==>Books==>Scripting Guide

Re: Question: Can JMP do a Full Outer Join without renaming the fields (scripting, info)

Newbie2Jumpie — Fri, 28 Jun 2019 08:33:14 GMT

Bingo!

I stubbornly stuck to the JSL Reference...

That's why I prefer to ask people.

Thx!

Re: Question: Can JMP do a Full Outer Join without renaming the fields (scripting, info)

txnelson — Fri, 28 Jun 2019 08:39:54 GMT

1. The response that you marked as the solution, is not the solution. Please unmark it, and mark the response that provided the solution as the correct solution.

2. The Scripting Index is a great reference tool, but you need to read the Scripting Guide. All of the questions you have asked today you would not have asked the Discussion Community if you take the time to read the documention