Concatenating table rows with different column names

[o129041voo]

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

[o129041voo]

I'm using JMP Ver 17.

[jthi]

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]

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

[hogi]

hi @Sarah-Sylvestre , I just found 2 more wishes with the same idea:
Concatenate: column matching 

Concatenating table rows with different column names 

Concatenate: option to specify column name match 

could you please link the wishes. In total it's now 9 Kudos.