Inner Join Can't Merge Tables

[Former Member]

Hi,

Using lumira 1.20.

Trying to connect a magic file with personnel file.

Magic file includes the department ids as unique and personnel file includes personnel info with related professional info. 1-to-m relationship.

Lumira cannot perform the merge because of selected columns do not const a uniqe key.

Any thoughts?

[TammyPowlas]

Have you tried the left outer join, where you want to keep the data in the personnel file and merge with departments?

Could you share screen shots of how you tried this?  Use the camera icon to upload