Merge two tables with 'Replace cells by row' – Error?

Hey there,

I’m trying to merge two tables. Both consist of two columns each [id, name]. Table1 carries a series of id’s (duplicate id’s present) and empty cells for the name. Table2 has the information on the names for each id. I want to merge them, so that each cell holds a value, even though they are redundant.

When I use the Merge.DAT with ‘replace cells by rows’ it does the job only once per matching id. It does not fill the cell with a name for a duplicate id. Do I understand this method wrong or is there a little bug?

Thanks in advance.
Norman
merge_tables.tox (550 Bytes)

I don’t know if the merge DAT supports multiple matches - if you don’t have a huge table / need a solution right away you can get there with a script DAT:
merge_tables_script_dat.tox (1014 Bytes)

Hey Matthew,

thank you for your help. It works with the script.dat. It keeps up the performance even with longer tables and resulting higher cook times.

It still leaves me a bit baffled when I think about the method itself and why it might not support multiple matches … anyway, the script works!

Thanks again and have a good weekend!
*N