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; } } }

3475_en-US

liliconcom

Joining tables without changing matching column name

Is there a way to JOIN two tables by matching columns without ending up with 2 identical columns with different names?

Ex:

dt1 << Join With (dt2), by Matching Columns (:HH_ID = :HH_ID));

After I do this, HH_ID can no longer be found in the table, since it's now "HH_ID of dataset1".

Is there a way to keep just 1 column "HH_ID" in the resulting dataset?

Message was edited by: LPaz

Re: Joining tables without changing matching column name

Thanks! The "Merge Same Name Columns" option was exactly what I was looking for.

Re: Joining tables without changing matching column name

At the bottom of the Join dialog there's a check box for "Select columns for joined table". Use that and select only one of the matching columns.

Jeff

Re: Joining tables without changing matching column name

In the Join dialog you can check the option to Merge Same Name Columns. In the resulting joined table you can look at the embedded Source script to see how to script the same option.

Comments

There are no comments yet