nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Newbie2Jumpie

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

Accepted answers

Newbie2Jumpie

Bingo!

I stubbornly stuck to the JSL Reference...

That's why I prefer to ask people.

Thx!

All comments

txnelson

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

Newbie2Jumpie

Bingo!

I stubbornly stuck to the JSL Reference...

That's why I prefer to ask people.

Thx!

txnelson

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