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

[#1]

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

[#2]

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

[#3 · Accepted solution]

Bingo!

I stubbornly stuck to the JSL Reference...

That's why I prefer to ask people.

Thx!

[#4]

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