This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
0 Kudos

Concatenating table rows with different column names

Status: New Submitted by on ‎09-15-2023 04:56 AM
3 Comments (3 New)

Dear Sir/Madam,

 

I've been dealing with information (eg yield table) from different subcons, on same product.  However, the tables may contain slightly different column names but they're meant to be on the same column.  Hence merging the tables from all subcons is a nightmare!  

 

I have attached a simple table to illustrate what I need to accomplish.

 

If you could help to develop a command to merge tables with similar column names, that would help me (and JMP community) alot!  

 

Thank you in advance!

 

Best regards,

Voon Yean Ten

An engineer from Broadcom

 

See more ideas labeled with:
3 Comments
o129041voo
Level II
‎09-15-2023 04:57 AM
‎09-15-2023 04:57 AM

I'm using JMP Ver 17.

 

jthi
Super User
Super User
‎09-15-2023 05:16 AM
‎09-15-2023 05:16 AM

How should the user-interface look like/how should JMP be able to determine which columns to concatenate if the names aren't the same or if they aren't in same order? Would you manually link all the matching columns to form pairs?

o129041voo
Level II
‎09-18-2023 09:01 PM
‎09-18-2023 09:01 PM

Hi jthi,

 

Yes it should allow users to manually match the column names to form pairs, and allow users to save the template for subsequent use.

 

Those columns that are not matched shall be put to the end of the concatenated table.

 

Regards,

o129041voo